Article updated on April 17, 2018

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

Formula in cell D3:

=ISERROR(B3)

Excel Function Syntax

ISERROR(value)

Arguments

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

Comments

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