TYPE Function
Returns a number telling you what kind of value something is.
Category
Information
Available in
All versions, Microsoft 365
Returns
1, 2, 4, 16, 64 or 128
Want to practice TYPE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
TYPE classifies a value: 1 number, 2 text, 4 logical (TRUE/FALSE), 16 error, 64 array, 128 compound data (such as a Stocks or Geography data type).
Unlike the IS functions, one formula tells you the kind — handy for checking imported data or for a LAMBDA that behaves differently for text and numbers.
Syntax
=TYPE(value) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value | Yes | Any value, cell or formula. |
Examples
Example 1 — What kind of value is it?
A date is a number, and a blank cell counts as a number too.
B2fx=TYPE(A2)
| A | B | |
|---|---|---|
| 1 | Value | TYPE |
| 2 | 125 | 1 |
| 3 | 3/15/2026 | 1 |
| 4 | Northstar | 2 |
| 5 | TRUE | 4 |
| 6 | #DIV/0! | 16 |
| 7 | 1 |
=TYPE(A2) Explain
Common mistakes
- A formula cell. TYPE looks at the formula's result, not at the fact it's a formula. Use ISFORMULA for that.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.