Nested IF

  • Thread starter Secret Squirrel
  • Start date
S

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

David Biddulph

You wanted the logical value TRUE but your formula looks for the text string
"TRUE". Ditch the quotes.
 
Top