Spread Formula Reference
Formula Functions / Functions T to Z / 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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

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