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

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

n/a

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

Summary Remarks Examples Related functions FAQ Does IFERROR catch all error types?Runtime metadata