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?
|