MS Excel: Type Function
In Excel, the Type function returns the type of a value.
The syntax for the Type function is:
Type( value )
value can be text, numbers, logical values (TRUE or FALSE), arrays, or errors.
Value Returned Number 1 Text 2 Logical value
(ie: TRUE or FALSE)4 Error value 16 Array 64
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Type(B2) would return 16 =Type(B3) would return 2 =Type(B4) would return 1