Home » Our Blog » Excel – Hiding errors using the IFERROR function

Excel – Hiding errors using the IFERROR function

PROBLEM: Dealing with formulas that result in error messages.  For example the #DIV/0 error or the #N/A error.

SOLUTION: Start using the IFERROR function 

 

Excel 2007, 2010, 2013 & 2016 – The IFERROR function

Use the IFERROR function to hide the contents of a cell if an error occurs.  For example if a value is divided by 0 or an empty cell the #DIV/0 error is displayed.  Another example is when a lookup function cannot find a match it will return the #N/A error.

To hide errors use the very clever IFERROR function.

If you have been using the ISNA, ISERROR or ISERR functions inside an IF function you will appreciate this function.  No more having to copy and paste long formulae multiple times. Just write it once and let Excel do the rest!

In the example below D4 is returning an error because B4 and C4 are empty cells.

Using the IFERROR function the error can be hidden.  Just place the IFERROR function around the calculation.  Insert a comma at the end of the calculation and then the data you would like returned into the cell if an error is calculated.  In the example below “” will return an empty cell.

Once B4 and C4 have content an error will no longer be created and the calculation result will be displayed instead.

Note: if your file is to be opened using an old version of Excel (2003 or earlier) this function will not work and will instead show an error.

If you found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
https://excelatwork.co.nz/2014/03/12/hide-my-errors