TYPE function in Excel

TYPE function in Excel


In the following article, Taimienphi.vn introduces you to TYPE function in Excel with the function to determine the information data type, this is one of the functions in the group of information functions that are commonly used in Excel.


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.

Attention:

– 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:

ham type in excel 2

Step 1: In the cell to calculate, enter the formula: = TYPE (B3)

ham type in excel 3

Step 2: Press Enter -> return value is:

ham type in excel 4

Step 3: Similarly, copying the formula to the remaining values ​​will result as shown below:

ham type in excel 5

Case Value is the error value, for example 10 + abc -> The result is an error value -> The function returns the value 16.

ham type in excel 6

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.

https://thuthuat.taimienphi.vn/ham-type-trong-excel-43745n.aspx
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.

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *