ReferenceFunctionsLogical (Extended) Functions

IFNA

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

Summary

IFNA(value, value_if_na) is narrower than IFERROR.

Remarks

Only #N/A triggers fallback.
Other error kinds are returned unchanged.
Non-error results pass through unchanged.
Exactly two arguments are required; other arities return #VALUE!.

Examples

Catch N/A

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

missing

Do not catch other errors

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

#DIV/0!

FAQ

Which errors does IFNA intercept?

Only #N/A is intercepted; all other errors pass through unchanged.

Runtime metadata

Category

Logical Ext

Signature

IFNA(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

IFERROR

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

IFS

IFS: Returns the value for the first TRUE condition in condition-value pairs.

On this page

Summary Remarks Examples Related functions FAQ Which errors does IFNA intercept?Runtime metadata