iserror

Test whether a value is any error.

Syntax

v = iserror(value)

Description

Returns true if value is any error type — #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!. Use iferror(...) (in Logical category) for error-handling expressions.

Example

iserror(1/0)             % 1

See also

• iserr — Test for any error except #N/A.
• isna — Test whether a value is #N/A.
• errortype — Numeric code identifying an error.