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.

Get the type of value in a cell

A numeric code representing type

=TYPE (value)

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

Type code | Meaning |
---|---|

1 | Number |

2 | Text |

4 | Logical value |

16 | Error value |

64 | Array |