Difference between ISNA and ISERROR
 

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

Difference between ISNA and ISERROR
 

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.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Louise" wrote:

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

Difference between ISNA and ISERROR
 

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.

--
Biff
Microsoft Excel MVP


"Louise" wrote in message
...
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