ReferenceFunctionsInformation Functions

ISNUMBER

ISNUMBER: Returns TRUE when the value is numeric.

Summary

This includes integer, floating-point, and temporal serial-compatible values.

Remarks

Returns TRUE for Int, Number, Date, DateTime, Time, and Duration.
Text that looks numeric is still text and returns FALSE.
Errors are treated as non-numeric and return FALSE.

Examples

Number is numeric

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

true

Numeric text is not numeric

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

false

FAQ

Does numeric-looking text count as a number?

No. ISNUMBER checks the stored value type, so text like "42" returns FALSE.

Runtime metadata

Category

Information

Signature

ISNUMBER(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISNA

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

ISODD

ISODD: Returns TRUE if number is odd.

On this page

Summary Remarks Examples Related functions FAQ Does numeric-looking text count as a number?Runtime metadata