Excel functions / Information

TYPE function

A number for the kind of value: 1 number, 2 text, 4 TRUE or FALSE, 16 error, 64 array.

Syntax

=TYPE(value)

Arguments

When to use it

TYPE gives a number for the kind of value it is given: 1 for a number, 2 for text, 4 for TRUE or FALSE, 16 for an error and 64 for an array. It answers "what is in this cell?" in one function where the IS functions take several.

Examples

  1. Number or text?

    ABC
    1Value
    2'422

    In C2: =TYPE(A2) → 2

    The apostrophe made it text.

    Try this example

  2. A number

    ABC
    1Value
    2421

    In C2: =TYPE(A2) → 1

    Try this example

Common mistakes

TYPE in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try TYPE in the playground

Related functions