Excel Function : TYPE
Category
Information
Description
Returns a number indicating the data type of a value
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TYPE-function-45b4e688-4bc3-48b3-a105-ffa892995899
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.
