TRUE - Boolean vs. Text
"Epinn" wrote in message
...
Yes, I agree with both of you.
As a matter of fact, ISNA is probably *the* way to capture #N/A error
because COUNTIF......#N/A purely won't work and not because it doesn't
look right.
Not that it doesn't look right, it shouldn't work because #N/A is not text.
I think it only works because of poor coding, it wasn't designed to do so (a
personal view)
=COUNTIF(B1:B6,"#N/A") ...... I know it works ...... <<<
If I am not mistaken, COUNTIF ......"#N/A" or "#N/A*" only WORKS in
capturing *text* "#N/A" and not the error #N/A. Unlike
COUNTIF ...... TRUE, there is no way to use COUNTIF ...... #N/A
(without quotes like TRUE) to count the error. So, looks like ISNA is the
way.
No, you are wrong there, it counts true #N/As, either a simple =NA() or as a
result of another more complex conditional function.
|