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?

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?

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?