Spread Formula Reference
Formula Functions / Functions D to G / ERRORTYPE
In This Topic
    ERRORTYPE
    In This Topic

    This function returns a number corresponding to one of the error values.

    Syntax

    ERRORTYPE(errorvalue)

    Arguments

    The valid error values that can be used in the arguments and their corresponding returned values are summarized here:

    Error Value Function Returns
    #NULL! 1
    #DIV/0! 2
    #VALUE! 3
    #REF! 4
    #NAME? 5
    #NUM! 6
    #N/A 7

    Remarks

    You can use this function in an IF-THEN structure to test for the error value and return a text string, such as a message, instead of the error value.

    Data Types

    Accepts error value as data. Returns numeric data.

    Examples

    ERRORTYPE(B13)

    ERRORTYPE(R13C2)

    ERRORTYPE(#REF!) gives the result 4

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ISERROR | Information Functions