The Excel ERROR.TYPE Function

Basic Description

The Excel Error.Type function receives an error value and returns an integer, that tells you the type of the supplied error.

The syntax of the function is:

ERROR.TYPE( error_val )

Where the supplied error_val is a value (or a reference to a cell containing a value), that you want to return the error type of.

The integers returned by the Excel Error.Type function, and their corresponding error types are listed in the table below:

1-#NULL!
2-#DIV/0!
3-#VALUE!
4-#REF!
5-#NAME?
6-#NUM!
7-#N/A
#N/A-Anything else

See the Excel Formula Error page for more information on each of these error types.


Error.Type Function Examples

Column B of the following spreadsheet shows four examples of the Error.Type function.

 Formulas:
 AB
1#VALUE!=ERROR.TYPE( A1 )
2#REF!=ERROR.TYPE( A2 )
3 =ERROR.TYPE( 1/A3 )
410=ERROR.TYPE( A4 )
 Results:
 AB
1#VALUE!3
2#REF!4
3 2
410#N/A

Note that the last example, in cell B4, tests the contents of cell A4, which is not an error. Therefore, the Error.Type function returns the #N/A error.


Further details on the Excel Error.Type function are provided on the Microsoft Office website.