Excel Formula - If ...or ...and ...or ....and

[Tracy in Calfifornia]

I want to use multiple values within conditions to check for validity. Example: If a=3 and b=4 or if a=5 and b=8 or if a=15 and b= 27 then "pass' else "fail". How do I compose a formula for this?

 

[Tazguy37]

With your two values a and b in cells D7 and E7, respectively:
=IF(OR(AND(D7=3,E7=4),AND(D7=5,E7=8),AND(D7=15,E7=27)),"pass","fail")

This will currently give "fail" if both are blank. Post back if that's not what you want. Hope that helps!

 

[tactps]

Welcome.

=if(or(and(a=3,b=4),and(a=5,b=8),and(a=15,b=27)),"Pass","Fail")

Replace a and b with the cell references.

e.g.:
=IF(OR(AND(A1=3,B1=4),AND(A1=5,B1=8),AND(A1=15,B1=27)),"Pass","Fail")

 

[Tracy in Calfifornia]

I think that will work for me...thanks!