iserr

Test for any error except #N/A.

Syntax

v = iserr(value)

Description

Like iserror but excludes #N/A. Useful for catching computational errors while letting #N/A (typically meaning “data not available”) propagate.

Examples

iserr(1/0)               % 1
iserr(NA())              % 0

See also

• iserror — Test whether a value is any error.
• isna — Test whether a value is #N/A.