This function returns the type of value.
TYPE(value)
The argument is any value as summarized here:
Type of Value | Returned Number |
---|---|
Number | 1 |
DateTime object | 1 |
TimeSpan object | 1 |
Text | 2 |
Logical value | 4 |
Error value | 16 |
Array | 64 |
Accepts many types of data. Returns numeric data.
TYPE(G15)
TYPE(R15C7)
TYPE(154) gives the result 1
TYPE("String") gives the result 2
TYPE(TRUE) gives the result 4