TYPE (type of a value)

<< Click to Display Table of Contents >>

TYPE (type of a value)

Syntax:

TYPE(Value)

Description:

Returns the type of the specified Value.

The following table shows which number results for which type:

"Value" is a ...

Result

Number or empty cell

1

Text string

2

Logical value

4

Error value

16

Array

64

Example:

TYPE(42) returns 1

If A1 contains the text string "Text":

TYPE(A1) returns 2

See also:

ERRORTYPE