<< Click to Display Table of Contents >> TYPE (type of a value) |
Syntax:
TYPE(Value)
Description:
Returns the type of the specified Value.
The following table shows which number results for which type:
"Value" is a ... |
Result |
Number or empty cell |
1 |
Text string |
2 |
Logical value |
4 |
Error value |
16 |
Array |
64 |
Example:
TYPE(42) returns 1
If A1 contains the text string "Text":
TYPE(A1) returns 2
See also: