<< Click to Display Table of Contents >> TYPE (type of a value)

Syntax:

TYPE(Value)

Description:

This returns the type of the specified Value in the form of a number.

You can see which number stands for which type in the following table:

Example:

TYPE(42) returns 1

If A1 contains the text string "Text", the following applies:

TYPE(A1) returns 2

See also:

ERRORTYPE