Returns 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.
- 1: if
- 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.