Formualizer Docs
ReferenceFunctionsInformation Functions

T

Returns text when input is text, otherwise returns empty text.

Summary

Returns text when input is text, otherwise returns empty text.

Remarks

  • Text values pass through unchanged.
  • Errors propagate unchanged.
  • Numbers, booleans, and blanks return an empty string.

Examples

Text passthrough
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
report
Number becomes empty text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected

FAQ

Does T hide non-text values?

Yes. Non-text inputs become an empty string, but errors are still propagated.

Runtime metadata

Category

Information

Signature

T(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

NA

NA: Returns the `#N/A` error value.

TYPE

Returns an Excel TYPE code describing the value category.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes T hide non-text values?Runtime metadata