TYPE
Definition of TYPE
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.
In order to use the TYPE formula, start with your edited Excellentable
Then type in the TYPE Formula in the area you would like to display the outcome:
Type in the complete TYPE formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.