Ads

Monday, 16 January 2017

Multiple ifs

This formula is to have multiple values of Multiple conditions.

=If(criteria1,then,If(criteria2,then,If(criteria3,then,....)

Criteria: Is the logic that you want.

Then: If the Criteria or logic is true then want should be the value. Remember to add double inverted commas for text.

Else: If the Criteria or logic is false then want should be the value. Remember to add double inverted commas for text.

No comments:

Post a Comment