Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Countif Text equals the same | Excel Discussion (Misc queries) | |||
Equals function | Excel Worksheet Functions | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
Can I change the Insert Function button to an equals sign? | Excel Discussion (Misc queries) |