The ERROR.TYPE function is an Information formula that returns an index number corresponding to a specific error value in Microsoft Excel. If there are no errors in the target cell(s), the function returns another error value, #N/A. This function can be especially useful in troubleshooting and error handling in your Excel models, as it can provide a quick overview of the existing issues. In this guide, we’re going to show you how to use the ERROR.TYPE function and also go over some tips and error handling methods.
- All Excel versions
ERROR.TYPE Function Syntax
|error_val||The error value you want to test. A common scenario is using a formula or a reference to a cell containing a formula that you want to test.|
Examples for Identifying Excel Errors
Use the this function to get a number value that indicates a specific error value. The return values and types are given in the table below:
To use this formula, all you need to to is to set a formula containing cell reference to the error_val argument to test its result. The result will give you the index number for the error type in the target cell.
- You can combine the ERROR.TYPE function with IF or IFNA functions for even better error handling in your Excel models.
- Other error related functions of Excel include:
- Please see Reducing Formula Errors in Excel to learn more about error-handling methods and workarounds.
- If the error_val argument doesn't contain any errors, the function returns the #N/A error value.