Spread Formula Reference
ERRORTYPE
Formula Functions > Functions D to G > ERRORTYPE

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