IF equals this OR this

[Guest]

I want a function in cell A1 that writes 'X' if cell D1 equals the value in
either cell E1 or E2.

 

[N Harkawat]

=if(or(d1=e1,d1=e2),"X","")

 

[swatsp0p]

try this in A1:

=IF(OR(D1=E1,D1=E2),"X","")


Good Luck

Bruce

 

[moi]

=IF(OR(D1=E1,D1=E2),"X","None of them")