ISERROR

ISERROR(value)[source]

Checks whether a value or array contains an error.

  • Returns True for elements that represent an error.

  • Returns False for elements that are valid values.

  • Works for both scalar values and arrays.

Parameters:

value (Operand | Any) –

The value to check for errors.

Supported types:

  • ANY

Return type:

Formula

Returns:

A formula indicating error status.

Supported types:

  • BOOLEAN

  • BOOLEAN_ARRAY

Examples

Scalar value:

ISERROR(123)
# Returns False

Array of values:

ISERROR([123, "abc", ERROR_VALUE])
# Returns [False, False, True]