The following article introduces you to the TYPE function - one of the functions in the information function group is very popular in Excel.
Description: The function returns the data type of any value. Application of functions in functions depends on the type of value.
Syntax: TYPE (value)
Inside:
- value: Any value to determine the data type, is a required parameter, the return value of the function corresponds to the data type as follows:
+ value in numeric form -> function returns value 1.
+ value in text form -> function returns value 2.
+ value is a logical value -> the function returns 4.
+ value are error values -> the function returns 16 value.
+ value in array form -> function returns 64 value.
Attention:
- TYPE function is most useful when combined with functions that use many different data types such as ARGUMENT, INPUT.
- Cannot use TYPE function in determining whether cell contains formula or not.
For example:
Determine the data type of the values described in the following table:
- In the cell to calculate enter the formula : = TYPE (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Where value is an error value, for example 6 + abc -> the result is an error value -> the function returns value 16.
Above are instructions and some specific examples when using TYPE function in Excel.
Good luck!