ERROR.TYPE Function in Google Sheets

Identify the error type of a value using the ERROR.TYPE function.

ERROR.TYPE Function

The ERROR.TYPE function in Google Sheets is used to identify the type of error present in a referenced cell.

Syntax

ERROR.TYPE(reference)
  • reference: The cell or formula whose error type you want to identify. This is a required parameter.

Example

  1. Identify Error Type

Find the error type of a division by zero error:

=ERROR.TYPE(A1/B1)

If A1 is 10 and B1 is 0, this will output 2, indicating a DIV/0 error.

Notes

  • The function returns a number corresponding to a specific error type (e.g., 1 for #NULL!, 2 for #DIV/0!).
  • ISERROR: Check if a value is an error.