IF equals this OR this

ellebelle · Jul 5, 2005

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

N Harkawat · Jul 5, 2005

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

swatsp0p · Jul 5, 2005

try this in A1:

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

Good Luck

Bruce

moi · Jul 5, 2005

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