Use the TYPE function in Excel to return the value type of a predefined data and return value is the number corresponding to that data type. For example: The numeric data type (Number), the TYPE function returns the number 1 … For more information, please follow the details of the content written below.
TYPE function in Excel
How to use the TYPE function in Excel
1. What is TYPE?
– This is the calculation function in Excel used to determine the value type.
– There are 6 types of values defined by a function TYPE in Excel, namely:
+ Value in the form of numbers -> the function returns the value 1.
+ Value in the form of text -> function returns value 2.
+ Value is a logical value -> the function returns 4.
+ Value is the error value -> the function returns the value 16.
+ Value in the form of arrays -> the function returns the value 64.
– Function TYPE Most useful when combined with functions that use many different data types such as functions ARGUMENT, INPUT.
– Cannot use function TYPE in determining whether a cell contains a formula.
2. Syntax and usage
Syntax: TYPE (Value)
Of which: Value is any value to determine the data type, is a required parameter, the return value of the function corresponds to the data type.
Suppose you need to determine the data type of the values described in the table below:
Step 1: In the cell to calculate, enter the formula: = TYPE (B3)
Step 2: Press Enter -> return value is:
Step 3: Similarly, copying the formula to the remaining values will result as shown below:
Case Value is the error value, for example 10 + abc -> The result is an error value -> The function returns the value 16.
Above is the tutorial with the same specific example when using TYPE function in Excel. With this function, you remember the syntax is TYPE (Value), Inside Value is any value to determine the data type, is a required parameter, the return value of the function corresponds to the data type. Wish you remember the recipe and succeed in working with it.
The Hlookup function is a row data lookup function that is used quite a lot in accounting, so you can learn more about Hlookup function via tips article that was shared on Taimienphi.vn.