ERROR.TYPE Function - Excel

Overview

The ERROR.TYPE function in Excel is a useful tool for identifying the type of error in a formula. This function helps you distinguish between different types of errors that might occur in a formula or cell.

The function will return the following outputs depending on the error:

  • 1: #NULL! error

  • 2: #DIV/0! error

  • 3: #VALUE! error

  • 4: #REF! error

  • 5: #NAME? error

  • 6: #NUM! error

  • 7: #N/A error

An example of the ERROR.TYPE function in Excel

Example:

=ERROR.TYPE(C2)

Syntax:

=ERROR.TYPE(error_val)

error_val: This is the error value or reference to a cell containing an error that you want to identify.

Interactive GSheet