| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple if statement
if the OP wnats to show acceptable only if al lconditions are true, probably
looking for the AND one. Took me a while to get through all the OR's myself. :-) "Don Guillett" wrote: try this, (untested) =IF(OR(A1="yes",Sheet2!A1="yes",Sheet3!A1="yes")," acceptable","not acceptable") -- Don Guillett Microsoft MVP Excel SalesAid Software "blake7" wrote in message ... 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
