ReferenceFunctionsInformation Functions

ISBLANK

ISBLANK: Returns TRUE only for a truly empty value.

Summary

Returns TRUE only for a truly empty value.

Remarks

Empty string "" is text, not blank, so it returns FALSE.
Numeric zero and FALSE are not blank.
Errors return FALSE.

Examples

Reference to an empty cell

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

true

Empty string is not blank

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

false

FAQ

Why does ISBLANK("") return FALSE?

Because an empty string is text, not a truly empty cell value.

Runtime metadata

Category

Information

Signature

ISBLANK(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ERROR.TYPE

ERROR.TYPE: Returns a number corresponding to an error type Returns: 1 = #NULL! 2 = #DIV/0! 3 = #VALUE! 4 = #REF! 5 = #NAME? 6 = #NUM! 7 = #N/A 8 = #GETTING_DATA (n…

ISERR

ISERR: Returns TRUE for any error except `#N/A`.

On this page

Summary Remarks Examples Related functions FAQ Why does ISBLANK("") return FALSE?Runtime metadata