Skip to main content

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:

ArgumentDescription
valueThe 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.

ISERROR Function