Using the Excel TYPE Function


The Excel TYPE function returns the type of a value expressed as a numeric code. Use TYPE when the operation of a formula depends on the type of value in a particular cell.


=TYPE (value)

Syntax Breakdown

Required. Any Microsoft Excel value. See the following table:

Value TYPE Returns
Number 1
Text 2
Logical value 4
Error value 16
Array 64

Usage Notes

TYPE returns a numeric code that represents the type of value. The function is useful when you are using other functions that can accept different types of data. TYPE can be used to figure out what type of data is being returned by the function or formula.

TYPE cannot be used to determine if a cell contains a formula. It will only return the type of value that the formula produces.