Skip to Content
Toggle navigation menu
Cheatsheets
Excel
Information
TYPE
Toggle user menu
TYPE
Returns the type of a value
Syntax
TYPE(value)
Parameters
value: Required. Can be any value (1=number, 2=text, 4=logical, 16=error, 64=array, 128=compound data)
Example
=TYPE(A1)
Returns:
Number
Since:
Excel 2003