Difference Between Evaluating 0 and False (or 1 and True)

[jdriscol]

Hi,

I was attempting to use the IFNA function, but I had it evaluating against a 0 instead of "False", only to find that it doesn't work that way. I found that using "FALSE" instead of the "0" in my code below fixed the formula.

Please Login or Register  to view this content.

Can someone explain to me the difference (or point me to an article) between using "0" and "FALSE" or "1" vs "TRUE" in this example?

Thank you.

[FlameRetired]

Excel is quite literal about comparing a logical to a number ... a different data type.

Try putting a double-unary preceding the ISNA like this

Please Login or Register  to view this content.

or adding 0 to the ISNA function

Please Login or Register  to view this content.

Either of those (or any math operation) will coerce the TRUE/FALSE output of ISNA to their underlying numeric values 1/0.