Fun with functions: Dealing with errors and the new Excel 2007 IFERROR() function

Simon Hurst explains how to use the new Excel 2007 function to streamline error-checking in your spreadsheets.

Sometimes a formula in a worksheet will return an error value. Perhaps one of the most common examples occurs when you are calculating one column of values as a percentage of another column and zero values result in #DIV/0 error messages.

If you want to avoid the printing of the error messages you could go to the sheet options tab of the Page Setup dialog and set the 'Cell errors as:' option.