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