| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple if statement
Hi I have the following if statement, it work fine if the relevant cells on
the sheet contain "yes", it shows "acceptable" but it shows FALSE when one cell contains "No" instead of showing "not acceptable" Where have I gone wrong. Thanks (Newbie) =IF(OR(A1="yes"),IF(OR(Sheet2!A1="yes"),IF(OR(Shee t3!A1="yes"),"acceptable","not acceptable"))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement with multiple criteria and multiple results | Excel Discussion (Misc queries) | |||
| Multiple IF statement | Excel Worksheet Functions | |||
| Multiple IF statement | Excel Discussion (Misc queries) | |||
| Help with multiple If statement | Excel Discussion (Misc queries) | |||
| Multiple If Statement | Excel Worksheet Functions | |||
Threaded Mode
