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

Syntax:

ISERR(Cell)

Description:

Unlike the ISERROR function, ISERR only returns TRUE if the given cell returns an error value other than #N/A.

Example:

ISERR(A1) returns TRUE if A1 contains an error value other than #NA.

ISERR(A1) returns FALSE if A1 does not return an error or if the NA() function is entered there.

See also:

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