The Excel TYPE Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Type-Function Search this site: Custom Search	Related Functions:  ISBLANK Function ISERROR Function ISLOGICAL Function ISNUMBER Function ISREF Function ISTEXT Function
Basic Description The Excel TYPE function receives a value and returns an integer, that represents the supplied value's data type.

The syntax of the function is:

Where the supplied value can be input either directly, as a value returned from a formula, or as a reference to a cell that contains a value.

The integers returned by the Excel Type function and their corresponding data types are shown in the table below :

Type Function Examples

The spreadsheets below show examples of the Excel Type function. The formulas are displayed 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 evaluated the empty cell B7 as the value 0. The function has therefore returned the integer 1, to denote a numeric value.

Further information and examples of the Excel Type function can be found on the Microsoft Office website.