We use cookies to improve our site and your experience. By continuing to browse on this website you accept the use of cookies. Find out more about our cookes policy.

How To Excel
How to use the IFERROR function

Our How To Excel series provides an overview of some of Microsoft Excel's functions and tools. In this article we will look at the IFERROR function.

What does the IFERROR() function do?

The IFERROR() function enables you to trap and handle errors in your formulae.

Syntax of the IFERROR() function


An example of how to use the IFERROR() function

Cell A1 contains a formula. We want to use the result of the formula that is in A1, however if the result of the formula is an error value (such as #N/A) then we want to return the phrase "Not found". The formula is therefore

=IFERROR(A1,"Not found")


Before this great new formula came along you needed to use the following formula to manage errors in Excel:=IF(ISERROR(Value),value_if_error,value)

Whilst this worked perfectly well you ended up with a long and sometimes difficult to audit formula. Also because of the repetition of the original formula it was inefficient.

A great step forward from Microsoft. The next step for the Microsoft team will be to build the error handler into the original formulae themselves. Fingers crossed...


Thoughts or questions inspired by this article? Call or email to share them with us.

Call +44 1225 350730

Email us