ISERR

Returns TRUE if the value is any error value except #N/A, and FALSE otherwise.

Parameter List

Syntax
ISERR(value)
value

The value to test for error conditions. Can be a cell reference, formula result, or direct value. For example: A1, 1/0, VLOOKUP("x",A1:B5,2,FALSE), or "text".

More details

ISERR returns TRUE for all error types except #N/A. The error types it detects include #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, and #NULL!. It returns FALSE for #N/A errors, numbers, text, logical values, blank cells, and any other non-error values. This makes it useful when you want to catch calculation errors but not treat #N/A as an error condition.

Examples

ISERR(1/0) returns TRUE, because 1/0 produces #DIV/0! error.