Lets say you want to know if B1 =5 and B2 = 10 or 20
=IF(AND(B1=5,OR(B2=10,B2=20),TRUE,FALSE)
Hopefully that provides some guidance.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John P." wrote:

I would like to combine AND and OR in an IF statement. What is the code? For
example, IF(......AND(a1=1, a2=2) OR(a3-"Yes",a4<0).
Thanks