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
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:
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