Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF
I'm trying to write a nested if but I'm getting a "FALSE" result.
Here is the statement I wrote. =IF(O379=0,IF(Q379="TRUE",IF(Z379="TRUE","")),X379 ) What I'm trying to say is this: If O379=0 and Q379=TRUE and Z379=TRUE then "" otherwise if X379 Where am I going wrong here? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Sub-Totals in Excel | Excel Discussion (Misc queries) | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |