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

ArgumentRequired?What it does
valueYesAny 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)
AB
1ValueTYPE
21251
33/15/20261
4Northstar2
5TRUE4
6#DIV/0!16
71
=TYPE(A2) Explain

Example 2 — Arrays

An array constant or a multi-cell range returns 64.

=TYPE({1,2,3}) 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

Kyle Stott

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.