Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell.
Syntax
TYPE(value)
Value can be any Microsoft Excel value, such as a number, text, logical value, and so on.
|
If value is |
TYPE returns |
|
Number |
1 |
|
Text |
2 |
|
Logical value |
4 |
|
Formula |
8 |
|
Error value |
16 |
|
Array |
64 |
Remarks
TYPE is most useful when you are using functions that can accept different types of data, such as ARGUMENT and INPUT. Use TYPE to find out what type of data is returned by the function.
Examples
If A1 contains the text "Smith", then:
TYPE(A1) equals TYPE("Smith") equals 2
TYPE("MR. "&A1) equals 2
TYPE(2+A1) equals TYPE(#VALUE!) equals 16
TYPE({1,2;3,4}) equals 64