Excel > Functions

IFERROR Function

The Excel IFERROR function is used to handle errors in a formula. IFERROR will perform a specified action if the formula evaluates to an error, and display the formula result if not.

The IFERROR function is only available from Excel 2007.

The syntax for the IFERROR function is:

=IFERROR(value, value_if_error)




The formula you are checking for an error


The action to take if the formula evaluates to an error

The example below shows the IFERROR function being used to return the text Product not found if the VLOOKUP function evaluates to an error message.

The VLOOKUP function is looking for C137, a product that does not exist. This would evaluate to a #N/A, but the IFERROR function detects the error and displays the required text instead.

The IFERROR function used to return text instead of an error message

Follow us on

Facebook  Twitter  You Tube 

Other Logical Functions

Excel 2010 Superhero Course