Difference between ISNA and ISERROR

[Louise]

Hi all

Can anybody explain the difference between these two functions? I've
created a report containing the ISNA function and a colleague has said that
they would have used the ISERROR function instead.

What is the difference between these two functions because if I change it to
ISERROR, I get the same results any way.

Thank you.
Louise

 

[Sheeloo]

ISERROR is the superset of ISNA so you can replace ISNA with ISERROR but you
can not use ISNA in place of ISERROR

Explanation: From Excel Help

ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!,
#NUM!, #NAME?, or #NULL!).
ISNA Value refers to the #N/A (value not available) error value.

Complete list of IS functions
Function Returns TRUE if -
ISBLANK Value refers to an empty cell.
ISERR Value refers to any error value except #N/A.
ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!,
#NUM!, #NAME?, or #NULL!).
ISLOGICAL Value refers to a logical value.
ISNA Value refers to the #N/A (value not available) error value.
ISNONTEXT Value refers to any item that is not text. (Note that this
function returns TRUE if value refers to a blank cell.)
ISNUMBER Value refers to a number.
ISREF Value refers to a reference.
ISTEXT Value refers to text.

 

[T. Valko]

ISERROR tests for *any and all* of the Excel error types:

#DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!

ISNA tests *only* for the #N/A error.