Learn How to Use Microsoft Excel ERROR.TYPE Function
In this article, you will learn how to use the Microsoft Excel ERROR.TYPE function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel ERROR.TYPE function return value and syntax with the help of some examples.
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
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
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