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

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

Chris Lane wrote:
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

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


"Aladin Akyurek" wrote in message
...
For #N/A, try ISNA. But what formula does produce it?

Chris Lane wrote:
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

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.

--
Regards,
Tom Ogilvy

"Chris Lane" wrote in message
...
Hi Aladin
sumif - but the question was a general one asked out of interest.
Thanks for the reply


"Aladin Akyurek" wrote in message
...
For #N/A, try ISNA. But what formula does produce it?

Chris Lane wrote:
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

Thanks Tom

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Chris Lane" wrote in message
...
Hi Aladin
sumif - but the question was a general one asked out of interest.
Thanks for the reply


"Aladin Akyurek" wrote in message
...
For #N/A, try ISNA. But what formula does produce it?

Chris Lane wrote:
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