| Syntax |
| =TYPE(value) |
| Purpose / Description |
| An older function in Excel to determine the value type of a value. |
| Arguments |
| Name |
Type |
Description |
| value |
any |
The value or value set whose type is to be determined. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
1 |
Indicates that value is a number value. Blank cells are coerced to 0 and so report as being numbers. |
| number |
2 |
Indicates that value is a text string. |
| number |
4 |
Indicates that value is a logical value. |
| number |
16 |
Indicates that value is an error value. |
| number |
64 |
Indicates that value is an array of values (including a multi-cell reference) but the type of the values in the array is not indicated. |
| Notes / Comments / Advice / Warnings |
| Comment: |
Not so widely used, and its inability to distinguish between blanks and numbers can occasionally be an issue. One of the specific value type functions will generally be more useful. |
| Examples: |
Open / download sample workbook: TYPE.xlsx |
| |