Return a value from excel using error. type function

After posting excel error what does it mean? my friends asked me, is there any formula for identifying an error and return a value produced by the excel formula. hence I have written below post which will help you further for debugging it and write the expectations whenever you have an error

ERROR.TYPE

This function will show a number which corresponds to an error produced by a formula.

Syntax: = ERROR.TYPE(Error)

Error is the cell reference where the error occurred.

Below is the example for Error.type. Please note the formatting of the result should be formatted as a normal number. (D column)



Explanation of each number returned by the Error.type formula. if you are new to my blog you can also refer to excel error what does it mean? for more information.