Tip Printed from ExcelTip.com

---

Nesting OR & AND Functions to Meet Multiple Criteria


Problem:

We want to create a formula that returns "1" if Num1=10 and either Num2=5 or Num3=2.
Otherwise, the formula is to return "0".

Solution:
Use the IF, AND, and OR functions as shown in the following formula:
=IF(AND(A2=10,OR(B2=5,C2=2)),1,0)