TYPE
Description
Returns an integer representing the data type of the specified value. 1 = Number, 2 = Text;
4 = Logical; 16 = Error; 64 = Array.
Syntax
TYPE(
value
)
- value: The value to return the data type for.
Example
Formula | Result |
|---|---|
=TYPE("phrase") | 2 |
=TYPE(TRUE) | 4 |
=TYPE({A, B, C}) | 64 |