Using the Excel TYPE Function
Summary
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.Syntax
=TYPE (value)Syntax Breakdown
ValueRequired. 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.