ERROR.TYPE Function Explained
The ERROR.TYPE Function in Microsoft Excel returns a number corresponding to an error type when given an error value. It takes a single argument, which is the error value, and returns a number from 1 to 8 corresponding to the following error types: #NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, #N/A, and #GETTING_DATA.
ERROR.TYPE Function Syntax
ERROR.TYPE(error_val)
- error_val: The error value for which you want the identifying number.