| Formula Functions > Functions T to Z > TYPE |
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
This function is available in product version 1.0 or later.
ERRORTYPE | ISERROR | ISLOGICAL | ISNUMBER | ISTEXT | Information Functions