| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if/or statement
ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER
NEEDED","CONTACT SUPERVISOR") how do I make this work |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if/or statement
Hi,
Try =IF(OR(D3=A1,D3=A2,D3=B5,D3=B6),"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR") -- Cheers, Shane Devenshire "dchristo" wrote: ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR") how do I make this work |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if/or statement
perfect, thank you very much
"ShaneDevenshire" wrote: Hi, Try =IF(OR(D3=A1,D3=A2,D3=B5,D3=B6),"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR") -- Cheers, Shane Devenshire "dchristo" wrote: ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR") how do I make this work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| IF/MAX statement | Charts and Charting in Excel | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
