ISERROR function

The ISERROR function is one of the information functions. It is used to check for an error value. If the cell contains one of the error values: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!, the function returns TRUE, otherwise the function returns FALSE.

Syntax

ISERROR(value)

The ISERROR function has the following argument:

Argument	Description
value	The value that you want to test. The value can be an empty cell, error, logical value, text, number, reference value, or a name referring to any of these.

Notes

How to apply the ISERROR function.

Examples

The figure below displays the result returned by the ISERROR function.