🏷️ Data Type Analyzer

Goal: Reveal the numeric code for a data type.
TYPE classifies data into 5 categories. Useful for testing if a cell contains an Array or Error.

?
TYPE CODE
--
1
Number
2
Text
4
Boolean
16
Error
64
Array
Ready...

💻 Formula Structure

=TYPE(value)
  • Value: The cell or data to evaluate.
  • Returns: An integer code (1, 2, 4, 16, or 64).
-- Check data type of A1
=TYPE( A1 )
Numeric Code:
-

⚠️ Notes

📅 Dates are Numbers
Since Excel stores dates as serial numbers, TYPE(Date) returns 1.
🚫 Empty Cells
TYPE(EmptyCell) returns 1 (Number) because empty cells are treated as 0 in math operations. Use ISBLANK to check for emptiness instead.