| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
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 |
Threaded Mode
