TYPE function
Summary
Returns a number indicating the data type of a value
Syntax
TYPE(value)
The TYPE function syntax has the following arguments:
• Value Required. Can be any Microsoft Excel value, such as a number, text, logical value, and so on.
Number | 1
Text | 2
Logical value | 4
Error value | 16
Array | 64
Compound data | 128
• Value Required. Can be any Microsoft Excel value, such as a number, text, logical value, and so on.
Number | 1
Text | 2
Logical value | 4
Error value | 16
Array | 64
Compound data | 128
Example
=TYPE(A2)
=TYPE("Mr. "&A2)
=TYPE(2+A2)
=(2+A2)
=TYPE({1,2;3,4})
=TYPE("Mr. "&A2)
=TYPE(2+A2)
=(2+A2)
=TYPE({1,2;3,4})