TYPE
Returns a number indicating the data type of a value.
InformationInformation & Auditing
What it does
Returns code for data type (1=Number, 2=Text, 4=Bool, 16=Error, 64=Array).
Syntax
TYPE(value)
Arguments
value(value) — Cell or value.
Examples
Check Type
Type of 'Hello'.
FORMULA
=TYPE("Hello")RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | Hello |