Formualizer Docs
ReferenceFunctionsInformation Functions

TYPE

Returns an Excel TYPE code describing the value category.

Summary

Returns an Excel TYPE code describing the value category.

Remarks

  • Codes: 1 number, 2 text, 4 logical, 64 array.
  • Errors are propagated unchanged instead of returning 16.
  • Blank values map to numeric code 1 in this implementation.

Examples

Text type code
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Boolean type code
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
4

FAQ

How are errors handled by TYPE?

Errors are propagated unchanged instead of returning Excel's error type code 16.

Runtime metadata

Category

Information

Signature

TYPE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

T

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

LET / LAMBDA Functions

Generated reference pages for LET / LAMBDA functions.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are errors handled by TYPE?Runtime metadata