This function returns the type of value.
Syntax
TYPE(value)
Arguments
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 |
Data Types
Accepts many types of data. Returns numeric data.
Examples
TYPE(G15)
TYPE(R15C7)
TYPE(154) gives the result 1
TYPE("String") gives the result 2
TYPE(TRUE) gives the result 4
See Also