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.
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.