Functions
TYPE
Number indicating value type
Try it
When to use it
When should I use TYPE?
Use TYPE to inspect what kind of value occupies a cell — it returns 1 for numbers, 2 for text, 4 for booleans, 16 for errors, and 64 for arrays, letting you branch logic based on data kind.
Used in
Syntax
TYPE(value)Examples
=TYPE(42) // => 1
=TYPE("hello") // => 2
=TYPE(TRUE) // => 4