ERROR.TYPE

See also A-Z Spreadsheet Function List

Description Returns a number corresponding to an error.

Syntax ERROR.TYPE(error_ref)

error_ref is a cell reference.

Remarks The following table lists the error text and associated error numbers returned by this function.

Number Error text

1 #NULL!

2 #DIV/0!

3 #VALUE!

4 #REF!

5 #NAME?

6 #NUM!

7 #N/A

#N/A Other

See Also ISERR and ISERROR functions

Example ERROR.TYPE(A1) returns 2 if the formula in cell A1 attempts to divide by zero.