Learn How to Use Microsoft Excel ERROR.TYPE Function

Microsoft Excel ERROR.TYPE Function

The main function of Microsoft Excel ERROR.TYPE function tests the specific error type. It implies with the help of ERROR.TYPE function you can able to return the number corresponding to the particular error value. You can use this function to test the specific error type. In case there is not an error the function returns the #N/A.          

Return Value of ERROR.TYPE Function

The return value will be the error number or #N/A if no error.

Syntax of ERROR.TYPE Function

=ERROR.TYPE(error-value)

Where the arguments:

error-value: It is the type of error for which to get an error code.

How to Use Microsoft Excel ERROR.TYPE Function?

You can use the ERROR.TYPE function to get a number corresponding to a specific error value. Below we have also provided the keys 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.

The List of Error Code Keys

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

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel