ReferenceFunctionsInformation Functions

ISNA

ISNA: Returns TRUE only for the `#N/A` error.

Summary

Returns TRUE only for the #N/A error.

Remarks

Other error kinds return FALSE.
Non-error values return FALSE.
Useful when #N/A has special business meaning.

Examples

Check for N/A

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

true

Other errors are not N/A

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

false

FAQ

Does ISNA return TRUE for errors other than #N/A?

No. It returns TRUE only when the value is exactly #N/A.

Runtime metadata

Category

Information

Signature

ISNA(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISLOGICAL

ISLOGICAL: Returns TRUE when the value is a boolean.

ISNUMBER

ISNUMBER: Returns TRUE when the value is numeric.

On this page

Summary Remarks Examples Related functions FAQ Does ISNA return TRUE for errors other than #N/A?Runtime metadata