This function allows you to test an expression and returns TRUE if your given expression results in any error apart from #N/A. For this function the #DIV/0, #NAME, #NULL!, #NUM!, #REF!, or #VALUE! errors all result in TRUE and the #N/A error or any other value results in FALSE.

Syntax

ISERR(Value)

  • Value (required) – This is the value that is checked for an error.

Example

In this example we test a few values some of which are errors. Notice the #N/A error results in FALSE while the other errors result in TRUE.

=ISERR(A2)

ISERR ISERR function