Difference between ISNA and ISERROR

  • Thread starter Thread starter Louise
  • Start date Start date
L

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
 
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.
 
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.
 
Back
Top