Learn How to Use Microsoft Excel TYPE Function

Microsoft Excel TYPE Function

The main use of the Microsoft Excel "TYPE" Function is to get the type of value in the cell. So, you can able to return the numeric code representing "type" in 5 categories, that includes:

number = 1,

text = 2,

logical = 4,

error = 16, and

array = 64.

Use TYPE when the operation of a formula depends on the type of value in a particular cell.

Return Value of TYPE Function

The return value will be the numeric code representing the number.

Syntax of TYPE Function

=TYPE(value)

Where the arguments:

• value: It is the value to check the type of.

How to Use Microsoft Excel TYPE Function?

You can use the TYPE to test the value in a particular cell so that other functions that depend on the type can perform as expected. Below we have provided the table, that represents the possible type codes returned from the TYPE function and the meaning:

It  should be also noted that:

• With the help of the TYPE function, you can test for formulas because the TYPE function evaluates the result of formulas and functions.
• You can also use the TYPE function to evaluate the type of data that is returned by a function or formula.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel