Excel ERROR.TYPE Function

★ 20 minutes read

Just as it is with using other functions in Excel to solve different issues, there are ways to use the Excel ERROR.TYPE function. This post will guide you on how to use the Excel ERROR.TYPE function with syntax in Excel.

Excel ERROR.TYPE Function


=ERROR.TYPE (error_val)


The parameter error_val is the error you want to get an error code for. The Excel ERROR.TYPE function gets an error value (or number) and returns an integer that matches the particular error value. You can use the ERROR.TYPE function to check for the exact kinds of errors and then present a relevant message. For instance, if no error is found, the function returns #N/A.

The error code that can be returned by ERROR.TYPE:

Example 1



Figure 1: The Excel ERROR.TYPE function


In the figure above, we’ve clearly explored how to use the ERROR.TYPE function to test for specific kind of errors. The formula in cell D5 is:


Where B5 is the cell containing the value for wish we want to return its error type.


In most cases, the “error_val” will be provided as a reference to a cell containing the value you wish to return its error type

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment