ISERR

[Chris Lane]

If I use the ISERR function, it doesn't catch NA errors. To do this I would
need to use ISERROR. Why would I then need to use ISERR at all?
Thanks

 

[Aladin Akyurek]

For #N/A, try ISNA. But what formula does produce it?

 

[Chris Lane]

Hi Aladin
sumif - but the question was a general one asked out of interest.
Thanks for the reply

 

[Tom Ogilvy]

from help:

ISERR Value refers to any error value except #N/A.

#N/A is a valid return for many of the lookup functions. If you needed to
know if an error besides #N/A is being returned, it would be appropriate to
use ISERR.

As an example, if you had a table that that you wanted to use Vlookup with
and the returned values are calculated in the table. If the value returned
is #DIV/0! then ISERR could be used to test that the value being returned is
an error and not that the value being looked up is not found.

 

[Chris Lane]

Thanks Tom

from help:

ISERR Value refers to any error value except #N/A.

#N/A is a valid return for many of the lookup functions. If you needed to
know if an error besides #N/A is being returned, it would be appropriate
to
use ISERR.

As an example, if you had a table that that you wanted to use Vlookup with
and the returned values are calculated in the table. If the value
returned
is #DIV/0! then ISERR could be used to test that the value being returned
is
an error and not that the value being looked up is not found.