SpreadJS Documentation
TYPE
SpreadJS Documentation > Formula Reference > Formula Functions > 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

See Also