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.

Syntax

ERRORTYPE(reference)

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

Example

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