Navigation:  Formula Reference > Spreadsheet Formula Functions >

ERROR.TYPE

Previous pageReturn to chapter overviewNext page

 

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

Syntax

ERROR.TYPE(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

ERROR.TYPE(B13)

ERROR.TYPE(R13C2)

ERROR.TYPE(#REF!) gives the result 4

 

See Also

ISERROR