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