ERRORTYPE(error_val)
=ERROR.TYPE(A3)
The function can be used to return the error type number associated with a cell. For example, if cell A3 returns the #DIV/0! error, the formula would return 3. This number can then be used to determine what other functions should be used.
=IF(ERROR.TYPE(A3)<3,CHOOSE(ERROR.TYPE(A3),"Ranges do not intersect","The divisor is zero"))
The function can also be used to return text related to the error in a cell. In this example, the function returns the number 3 for the #DIV/0! error. This can then be used to display the text "The divisor is zero" in the cell.
The ERROR.TYPE function in Excel 2003 returns a numeric code based on a specific error value. It takes one argument, error_val, which should be an error message like #VALUE!, #DIV/0!, #NAME!, etc.