Author: Oscar Cronquist Article last updated on April 17, 2018

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

Formula in cell D3:


Excel Function Syntax



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


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