ReferenceFunctionsInformation Functions

ISTEXT

ISTEXT: Returns TRUE when the value is text.

Summary

Returns TRUE when the value is text.

Remarks

Only text literals return TRUE.
Numbers, booleans, blanks, and errors return FALSE.
No coercion from other types to text is performed for this check.

Examples

Detect text

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

true

Number is not text

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

false

FAQ

Is an empty string treated as text?

Yes. An empty string literal is still text, so ISTEXT("") returns TRUE.

Runtime metadata

Category

Information

Signature

ISTEXT(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ISODD

ISODD: Returns TRUE if number is odd.

N

Converts a value to its numeric representation.

On this page

Summary Remarks Examples Related functions FAQ Is an empty string treated as text?Runtime metadata