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
value: The value to check.
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
Number or text?
A B C 1 Value 2 '42 2 In C2:
=TYPE(A2)→ 2The apostrophe made it text.
A number
A B C 1 Value 2 42 1 In C2:
=TYPE(A2)→ 1
Common mistakes
- An empty cell. An empty cell counts as a number: TYPE gives 1. Use ISBLANK to find empty cells.
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.
- Czech: TYP
- Danish: VÆRDITYPE
- Dutch: TYPE
- Finnish: TYYPPI
- French: TYPE
- German: TYP
- Hungarian: TÍPUS
- Italian: TIPO
- Norwegian: VERDITYPE
- Polish: TYP
- Portuguese (Brazil): TIPO
- Portuguese (Portugal): TIPO
- Russian: ТИП
- Spanish: TIPO
- Swedish: VÄRDETYP
- Turkish: TÜR
Related functions
- ISNUMBER: TRUE if the value is a number (dates count too).
- ISTEXT: TRUE if the value is text.
- ISLOGICAL: TRUE if the value is TRUE or FALSE.
- ERROR.TYPE: A number for the kind of error: 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A.
- CELL: Tells you something about a cell: its address, row, column, contents, number format or the type of value in it.