ISERR

Checks whether the specified value is an error value, other than #N/A.

Syntax

ISERR( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is an error value other than #N/A, the function returns TRUE; in any other case the function returns FALSE. Note, that this function does not propagate error values.

Example

Formula

=ISERR(NA())
=ISERR(5/0)

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERROR Function
ISNA Function
ISREF Function
ISTEXT Function
TYPE Function