ISERROR function

This function allows you to test a expression and returns TRUE if your given expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!) and FALSE otherwise.

Syntax

ISERROR(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. Only the errors result in TRUE.
 

=ISERROR(A2)