ERRORTYPE function

ERRORTYPE returns the number corresponding to an error value occurring in a different cell. With the aid of this number, you can create an error message. If an error occurs, the function returns a logical or numerical value.



reference contains the address of the cell in which the error occurs.


If cell A1 displays Err:518, the function =ERRORTYPE(A1) returns the number 518.