Excel Function : TYPE

Download now!

Excel Function : TYPE




Returns a number indicating the data type of a value

Microsoft Excel Reference Page


Syntax and Description of the TYPE Excel Function

The syntax for the Excel TYPE function is: TYPE(value) The TYPE function takes one argument: value - the value to test and returns a number that indicates the data type of the value.

About TYPE Excel Function

The TYPE function returns a number that corresponds to the data type of a value. The following table shows the numbers that the TYPE function returns for each data type. Data type Number returned by TYPE Empty 0 Error 1 Logical 2 Text 3 Number 4 Date 5 The TYPE function is useful for determining the type of data in a cell. For example, if you want to make sure that a value is a number before performing a calculation on it, you can use the TYPE function to check the value's data type.