TYPEReturns a number associated with the type of data passed into the function.
Sample Usage
TYPE(C4)
TYPE({1;2;3;4;5})
Syntax
TYPE(value)
value – The data whose type is to be determined.
Notes
This function returns the following numbers:
1: if value is a number
2: if value is text
4: if value is boolean
16: if value is an error
64: if value is an array
128: for any other type of cell. For example, in-cell images and sparklines.
The function cannot determine whether or not a cell or range of cells is using a formula, only returning the type of value being displayed in the cells.
See Also
ISTEXT: Checks whether a value is text.
ISNUMBER: Checks whether a value is a number.
ISLOGICAL: Checks whether a value is `TRUE` or `FALSE`.
ISERROR: Checks whether a value is an error.