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.