Nested If and And

Hi James,

Thank you for your question.

Enjoy the following example:

=IF(AND(B7>25000,C7>15000),"Yes","No")

This example returns the answer of Yes or No depending on whether both sets of criteria match. If one matches and not the other then No will be returned. If both match then Yes will be returned.

=IF(OR(B7>25000,C7>15000),"Yes","No")

This example returns the answer of Yes if any one of the criteria is matched and will only return No when both criteria do not match.

I hope this answers your question.

Regards

Simon