"Jonathan Cooper" wrote:

=IF(OR(AND(A1=1,A2=2),B3=3),"do this if true","do something else if false")

in this example, if both A1 has the value of 1 and a2 has the value of 2, or
if just B3 has the value of 3), then the argument is true, else....not true.

"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

Very helpful and quick. Thanks for your attention.