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.

Return type:

Formula

Returns:

A formula indicating error status.

Examples

Scalar value:

ISERROR(123)
# Returns False

Array of values:

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

``value`` — accepted types

  • BOOLEAN

  • BOOLEAN_ARRAY

  • BOOLEAN_MAP

  • DATE

  • DATETIME

  • DATETIME_ARRAY

  • DATETIME_MAP

  • DATE_ARRAY

  • DATE_MAP

  • DECIMAL

  • DECIMAL_ARRAY

  • DECIMAL_MAP

  • INTEGER

  • INTEGER_ARRAY

  • INTEGER_MAP

  • NULL

  • OBJECT

  • OBJECT_ARRAY

  • STRING

  • STRING_ARRAY

  • STRING_MAP

  • TIME

  • TIME_ARRAY

  • TIME_MAP

Return types

  • BOOLEAN

  • BOOLEAN_ARRAY