Buzz
This article introduces you to the TYPE function, one of the commonly used functions in the information group in Excel.
Description: The function returns the data type of any given value. It is applied in functions dependent on the value type.
Syntax: TYPE(value)
In this context:
- value: Any value you want to determine the data type of, is a required parameter, and the function returns values as follows:
+ If value is numeric -> the function returns the value 1.
+ If value is text -> the function returns the value 2.
+ If value represents logical values -> the function returns the value 4.
+ If value represents error values -> the function returns the value 16.
+ If value is in array form -> the function returns the value 64.
Note:
- The TYPE function is most useful when combined with functions that utilize various data types such as ARGUMENT and INPUT functions.
- The TYPE function cannot be used to determine whether a cell contains a formula or not.
Example:
Determine the data type of the values described in the table below:
- In the cell where you want to calculate, enter the formula: =TYPE(C6)
- Press Enter -> the returned value is:
- Similarly, copy the formula for the remaining values to get the result:
- In the case where the value is an error value, for example 6 + abc -> resulting in an error value -> the function returns the value 16.
Above is the guide and some specific examples when using the TYPE function in Excel.
Wishing you all success!
