ERROR.TYPE

Definition: ERROR.TYPE is a function that returns a number corresponding to the type of error value in a cell.

Syntax: =ERROR.TYPE(error_val)

Situation: This formula is suitable when you need to identify the type of error value in a cell.

Example: If a cell contains the error value #VALUE!, the formula =ERROR.TYPE(A1) returns 3, which corresponds to the type of error.