Formualizer Docs
ReferenceFunctionsInformation Functions

ISNONTEXT

ISNONTEXT: Returns TRUE when the value is anything other than text.

Summary

Returns TRUE when the value is anything other than text.

Remarks

  • Text literals return FALSE.
  • Numbers, booleans, blanks, and errors return TRUE.
  • This is the logical complement of ISTEXT in the current engine semantics.

Examples

Number is non-text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Text is not non-text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

Do errors count as non-text values?

Yes. This implementation treats any non-text value, including errors, as TRUE for ISNONTEXT.

Runtime metadata

Category

Information

Signature

ISNONTEXT(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.

ISNUMBER

ISNUMBER: Returns TRUE when the value is numeric.

On this page

SummaryRemarksExamplesRelated functionsFAQDo errors count as non-text values?Runtime metadata