The Excel TYPE function returns a numeric code representing “type” in 5 categories: 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.
- value – The value to check the type of.
Use TYPE to test the value in a particular cell so that other functions that depend on the type can perform as expected.
You can use TYPE to find out the type of data that is returned by a function or formula.
You can’t use TYPE to test for a formula, because TYPE evaluates the result of formulas and functions.
The table below shows the possible type codes returned from TYPE and the meaning of each: