Easy one but I cannot get it to work!

[buteaur]

I'm trying to write a multiple if(or statement with three data points.

IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO")

Brings back "no" no matter what.

I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no.

Any help is appreciated!

 

[rlv01]

if the requirement is for any of the three criteria to be true then perhaps

=IF(OR(AA11046="AAA",AA11046="AAB",AC11046="YES"),"YES","NO")

if they ALL need to be true then

=IF(AND(AA11046="AAA",AA11046="AAB",AC11046="YES"),"YES","NO")*

update: oops. ignore that "AND" part, it would never evaluate to true anyway since the AAA and AAB test are on the same AA11046 cell

 

[buteaur]

Thank you. The first one I had written as well but does not work.

The second one won't give the desired results as they don't all need to be true.

Thank you very much for the response though!

 

[Fluff]

Is this what you want
=IF(AND(OR(AA11046="AAA",AA11046="AAB"),AC11046="YES"),"YES","NO")