TYPE

Get the type of value in a cell

Sponsored Link

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

 

Sponsored Link

0 votes. 0 / 5