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

[Chris Lane]

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


"Aladin Akyurek" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
Regards,
Tom Ogilvy

"Chris Lane" <[email protected]> wrote in message
news:[email protected]...
> Hi Aladin
> sumif - but the question was a general one asked out of interest.
> Thanks for the reply
>
>
> "Aladin Akyurek" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>

[Chris Lane]

Thanks Tom

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Aladin
>> sumif - but the question was a general one asked out of interest.
>> Thanks for the reply
>>
>>
>> "Aladin Akyurek" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>
>