Author: Oscar Cronquist Article last updated on May 04, 2022

The ISERROR function returns TRUE if a cell returns an error.

1. ISERROR Function Syntax

ISERROR(value)

Back to top

2. ISERROR Function Arguments

value Required. The value you want to check for an error.

 

Back to top

3. ISERROR Function Example

Formula in cell D3:

=ISERROR(B3)

The IFERROR function introduced in Excel 2007 is more useful, in my opinion. It allows you to define an error value, check it out.

Back to top