Returns a number indicating the type of the specified value.
Syntax
![]() |
---|
TYPE( Any value ) → Number |
The function returns a value indicating the type of the specified argument, according to the following table.
Type | Value |
---|---|
Number | 1 |
Text | 2 |
Logical | 4 |
Error | 16 |
Array | 64 |
If a reference is provided, the reference is first dereferenced, and any formulas are evaluated. Note that this function does not propagate error values.
Function Reference
ERROR.TYPE Function