The ERROR.TYPE function returns a numeric representation of an Excel error value. Using the numeric representation of an Excel error (consider it a numeric error code) can be more convenient to use in other formulas.

ERROR.TYPE takes 1 required argument and no optional arguments:

Syntax: ERROR.TYPE(error_val)

#1)
Using the ERROR.TYPE function:
Note
See also the ISERR and ISERROR functions.
#2)
Using the ERROR.TYPE number in other formulas:
#3)
The arguments for the ERROR.TYPE function are:
Argument Required? Description
error_val Required The error value whose identifying number you want to find. Although error_val can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.

Summary

The ERROR.TYPE function returns a numeric representation of an Excel error value and can be used to create more graceful error handling in your spreadsheet and is generally more convenient to use in other formulas.
comments powered by Disqus