How to use the Excel ERROR.TYPE function

Summary

The Excel ERROR.TYPE function returns a number that corresponds to a specific error value. You can use ERROR.TYPE to test for specific kinds of errors. If no error exists, ERROR.TYPE returns #N/A. See below for a key to the error codes returned by ERROR.TYPE.

Purpose

Test for a specific error value

Return value

An error number or #N/A if no error.

Syntax

=ERROR.TYPE (error_val)

Arguments

error_val - The error for which to get an error code.

Version

Excel 2003

Usage notes

Use ERROR.TYPE to get a number that corresponds to a specific error value. See below for a key to the error codes returned by ERROR.TYPE. If no error exists, ERROR.TYPE returns #N/A.

In most cases, error_val will be supplied as a reference to a cell that may contain an error value.

One way to use ERROR.TYPE is to test for specific errors and display a relevant message (instead of error values) when certain error conditions exist.

Error code key:

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