ISERR

C

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
 
C

Chris Lane

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

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.
 
C

Chris Lane

Thanks Tom

Tom Ogilvy said:
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.
Click to expand...
 
Top