Returns a number indicating the type of the specified value.
Syntax
 Copy Code
|
|---|
TYPE( Any value ) → Number |
Parameters
- value
- Required. The value to check.
Remarks
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.
See Also
Function Reference
ERROR.TYPE Function