Formualizer Docs
ReferenceFunctionsLogical (Extended) Functions

IFERROR

IFERROR: Returns a fallback when the first expression evaluates to any error.

Summary

IFERROR(value, value_if_error) is useful for user-friendly error handling.

Remarks

  • Any error kind in the first argument triggers the fallback branch.
  • Non-error results pass through unchanged.
  • Evaluation failures surfaced as interpreter errors are also caught.
  • Exactly two arguments are required; other arities return #VALUE!.

Examples

Replace division error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
n/a
Pass through non-error
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
42

FAQ

Does IFERROR catch all error types?

Yes. Any error kind in the first argument triggers the fallback value.

Runtime metadata

Category

Logical Ext

Signature

IFERROR(arg1: Any, arg2: Any)

Arity

min 2, max 2

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

Caps

PURE

Source

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

Logical (Extended) Functions

Generated reference pages for Logical (Extended) functions.

IFNA

IFNA: Returns a fallback only when the first expression is `#N/A`.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes IFERROR catch all error types?Runtime metadata