SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / TYPE
In This Topic
    TYPE
    In This Topic

    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