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!
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!