Excel like a finance pro.
← The libraryPractice · 2 questions →
Information function
TYPE
Returns a number for the type of value: 1 number, 2 text, 4 logical, 16 error, 64 array.
Rarely usedDifficulty 1200 · ProficientUsage rank #270 of 520
When to use it
A number for the type of a value: 1 number, 2 text, 4 logical, 16 error, 64 array.
The shape of it
- Syntax
=TYPE(value)
Worked examples
Number
=TYPE(123) → 1
A number.
Text
=TYPE("abc") → 2
Text.
Error
=TYPE(#N/A) → 16
An error.
Worth knowing
- Use SWITCH(TYPE(x),1,"number",2,"text",4,"logical",16,"error","array") for a readable label.
- Dates report 1, like any number.
- Blank cells report 1.
Where it goes wrong
- Cannot distinguish dates from numbers.
- The IS functions are clearer for a single test.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.