Formualizer Docs
ReferenceFunctionsInformation Functions

ISERROR

ISERROR: Returns TRUE for any error value.

Summary

Returns TRUE for any error value.

Remarks

  • Matches all error kinds, including #N/A.
  • Non-error values always return FALSE.
  • Arity mismatch returns #VALUE!.

Examples

Division error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Normal value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

Does ISERROR include #N/A?

Yes. ISERROR returns TRUE for all error kinds, including #N/A.

Runtime metadata

Category

Information

Signature

ISERROR(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

ISERR

ISERR: Returns TRUE for any error except `#N/A`.

ISEVEN

ISEVEN: Returns TRUE if number is even.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes ISERROR include #N/A?Runtime metadata