Nested IF

[Guest]

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?

 

[bobocat]

You can try
=if(and(o379=0,Q379=true, Z379=true),"",X379)

 

[David Biddulph]

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