| 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
|
|||
|
|||
|
=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. |
|
#4
|
|||
|
|||
|
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 |
| 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) | |||
Hybrid Mode
