ERROR.TYPE

Returns a number corresponding to the specified error value.

Syntax

ERROR.TYPE( Error e ) → Number

Parameters

e

Required. The error value.

Remarks

The following table contains the values that correspond to some of the predefined errors:

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

The parameter can be an actual error value or a reference to a cell containing a formula. If e is not an error value, the function returns the #N/A error value. The ERROR.TYPE function is useful in an IF function to test for an error value and return a text string, such as a message, instead of the actual error value.

Note that this function does not propagate error values.

Example

Formula

=ERROR.TYPE(1/0)

See Also

Function Reference
NA Function