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
|