Exceljet

Quick, clean, and to the point

Excel TYPE Function

Excel TYPE function
Summary 

The Excel TYPE function returns a numeric code representing "type" in 5 categories: number = 1, text = 2, logical = 4, error = 16, and array = 64. Use TYPE when the operation of a formula depends on the type of value in a particular cell.

Purpose 
Get the type of value in a cell
Return value 
A numeric code representing type
Syntax 
=TYPE (value)
Arguments 
  • value - The value to check the type of.
Usage notes 

Use TYPE to test the value in a particular cell so that other functions that depend on the type can perform as expected. The table below shows the possible type codes returned from TYPE and the meaning of each:

Type code Meaning
1 Number
2 Text
4 Logical value
16 Error value
64 Array

Notes:

  • You can't use TYPE to test for a formula, because TYPE evaluates the result of formulas and functions.
  • You can use TYPE to find out the type of data that is returned by a function or formula.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.