Yes the false path produces the N/A

Tyro

"T. Valko" wrote in message
...
the formula evaluates as false, so you get #N/A as an answer

Not exactly. If OR evaluated to FALSE then the result of the formula would
be the IF_value_if_false argument.


--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
et...
=IF(ISNA(F12),"",IF(F12=0,"",F12))

The OR function evaluates both contitions. If the cell F12 contains an
error #N/A, the comparison F11=0 produces an error and the formula
evaluates as false, so you get #N/A as an answer. You can see this using
formula evaluator.

Tyro

"luvnrocs" wrote in message
...
I'm trying o figure out why this formula isn't working as expected.

I need to check in a column to see if any cells have the number zero
or #NA. If either condition is true, OR should return "True" and then
make the destination cell blank. If neither condition is met then OR
returns "False" and the value from F11 is copied to G11.

This formula is in cell G11:

=IF(OR(ISNA(F11),F11=0),"",F11)