Formualizer Docs
ReferenceFunctionsInformation Functions

ISERR

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

Summary

Returns TRUE for any error except #N/A.

Remarks

  • #N/A specifically returns FALSE.
  • Other errors such as #DIV/0! or #VALUE! return TRUE.
  • Non-error values return FALSE.

Examples

DIV/0 is an error excluding N/A
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
N/A is excluded
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

What is the difference between ISERR and ISERROR?

ISERR excludes #N/A, while ISERROR treats #N/A as an error too.

Runtime metadata

Category

Information

Signature

ISERR(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISBLANK

ISBLANK: Returns TRUE only for a truly empty value.

ISERROR

ISERROR: Returns TRUE for any error value.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat is the difference between ISERR and ISERROR?Runtime metadata