Spread Formula Reference
TYPE
Formula Functions > Functions T to Z > TYPE

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