TYPE

Get the type of value in a cell

TYPE

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.

You can use TYPE to find out the type of data that is returned by a function or formula.

You can't use TYPE to test for a formula, because TYPE evaluates the result of formulas and functions.

The table below shows the possible type codes returned from TYPE and the meaning of each:

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

 

0 votes. 0 / 5