ERROR.TYPE function

The ERROR.TYPE function is one of the information functions. It is used to return the numeric representation of one of the existing errors.

Syntax

ERROR.TYPE(error_val)

The ERROR.TYPE function has the following argument:

Argument	Description
error_val	An error value. The possible values are listed in the table below.

The error_val argument can be one of the following:

Error value	Numeric representation
#NULL!	1
#DIV/0!	2
#VALUE!	3
#REF!	4
#NAME?	5
#NUM!	6
#N/A	7
#GETTING_DATA	8
Other	#N/A

Notes

How to apply the ERROR.TYPE function.

Examples

The figure below displays the result returned by the ERROR.TYPE function.