IsError

Determines whether or not a value corresponds to an error.

Syntax

IsError(val)
EstErreur(val)
val = the value to check if it is an error

Remarks

Only strings with a form of #xxx! are recognized as errors, other values are not recognized as errors.

Special case of non-finite numbers: non-finite numbers (+INF, NaN, etc.) are not strictly errors as they are part of IEEE 754 when values of formulas, but converting them to string will lead to a #VAL!. To test for non-finite numbers, see IsFinite.

See also and IfError.

Examples

IsError("hello") = False
IsError("#VAL!") = True
IsError("") = False

Classification

Logic