IF equals this OR this
 

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

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

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

try this in A1:

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


Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384537

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

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