| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
Hi,
I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine an "IF" and "OR" statement | Excel Worksheet Functions | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| How to combine IF statement and Vlookup function? | Excel Discussion (Misc queries) | |||
| combine IF, AND and OR operstors in a statement | Excel Worksheet Functions | |||
| HLookup, IF statement, multiple sort, somehow combine all of these | Excel Worksheet Functions | |||
Threaded Mode
