Excel 2000 in a Nutshell

Name

TYPE

Synopsis

Use TYPE to determine the type of value contained in a cell. This function is useful for ensuring that a cell contains the desired type of value before performing a calculation. The function returns one of the following integer values identifying the type of contents in the cell:

1

Number

2

Text

4

Logical value

16

Error value

64

Array

To Calculate

=TYPE(Value)

Example

Figure 20-4 illustrates how to use TYPE to determine the type of value contained in each cell in column A.

Cell Type Value

The TYPE function returns an integer value of 1, 2, 4, 16, or 64, all of which correspond to the type of value in the cell.