This function returns the type of value.

Syntax

TYPE(value)

Arguments

The argument is any value as summarized here:

Type of Value	Returned Number
Number	1
DateTime object	1
TimeSpan object	1
Text	2
Logical value	4
Error value	16
Array	64

Data Types

Accepts many types of data. Returns numeric data.

Examples

TYPE(G15)

TYPE(R15C7)

TYPE(154) gives the result 1

TYPE("String") gives the result 2

TYPE(TRUE) gives the result 4

Version Available

This function is available in product version 1.0 or later.

See Also

ERRORTYPE | ISERROR | ISLOGICAL | ISNUMBER | ISTEXT | Information Functions