Returns a number corresponding to the error value in a different cell. Learn more
In Google Sheets, ERROR.TYPE(reference) is a function that helps to identify the type of error that is occurring in a particular cell or formula. The function takes a reference as its argument, which can be either a cell reference or a formula, and returns a numerical value that corresponds to the type of error.
The numerical values returned by ERROR.TYPE() are as follows:
By using the ERROR.TYPE() function, you can easily identify the type of error that is occurring in a cell or formula, which can help you to troubleshoot and correct the error.