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. However, this will hide any error messages on the sheet and thus possibly cover up vital warnings in other areas of the sheet:
A more specific approach would be to trap the error before it occurs using an IF() function...