The Excel TYPE function receives a value and returns an integer, that tells you the supplied value's data type.
The format of the function is :
TYPE( Value )
Where the supplied Value can be input directly or can be a reference to a cell.
The integers returned by the Excel Type function and their corresponding data types
are shown in the table below :
1
Number
2
Text
4
Logical Value
16
Error Value
64
Array
Examples
The following spreadsheets show examples of the Excel Type function. The format of the function
is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Note that, in the example above, the Type function in cell A7, has treated the empty cell B7 as containing
the value 0. The function has therefore returned the integer 1, to denote a numeric value.
