| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF
You can try
=if(and(o379=0,Q379=true, Z379=true),"",X379) "Secret Squirrel" ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF
You wanted the logical value TRUE but your formula looks for the text string
"TRUE". Ditch the quotes. -- David Biddulph "Secret Squirrel" wrote in message ... 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? |
| Reply |
| 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 | |||
Linear Mode
