ERROR.TYPE

Returns a number corresponding to the error value in a different cell.

Sample Usage

ERROR.TYPE(A3)

ERROR.TYPE(NA())

Syntax

ERROR.TYPE(reference)

• reference - The cell to find the error number for - you can also provide the error value directly.

Notes

• ERROR.TYPE will return the following numbers for the corresponding error values:
  • 1 for #NULL!
  • 2 for #DIV/0!
  • 3 for #VALUE!
  • 4 for #REF!
  • 5 for #NAME?
  • 6 for #NUM!
  • 7 for #N/A
  • 8 for all other errors

See Also

ISNA : Checks whether a value is the error `#N/A`.

ISERROR : Checks whether a value is an error.

ISERR : Checks whether a value is an error other than `#N/A`.

Examples

Click to open document