<< Click to Display Table of Contents >> ISERR (is an error value other than #N/A?)

Syntax:

ISERR(Reference)

Description:

Unlike the ISERROR function, ISERR only returns TRUE if the specified cell contains any kind of error value except #N/A.

Example:

ISERR(A1) returns TRUE if A1 contains any kind of error value except #NA.

ISERR(A1) returns FALSE if A1 contains the error value #N/A or any kind of value that is not leading to an error value.

See also:

ISERROR, ISNA, NA(), ERRORTYPE, IFERROR, section Error values