How to Hide Error Messages

**TPS** · 08-14-2012, 11:27 PM

Hi All, I'm new here. I am having issues with error messages preventing basic sum, multiply and divide calculations using resident formulas. The errors also look untidy. The spreadsheet contains basic formulas that calculate percentages and commissions extracted across a row in a data table that is pasted into the sheet using a macro. The formulas reside on the sheet permanently adjacent to the target range for the table. If a relevant cell value is 0 the calculation returns a #DIV/0!. In that instance the adjacent cell then returns #VALUE! error message. The relevant formulas are;in Cell R8 =+G8/F8 (Error #DIV/0! when either value is 0) and in Cell S8 =+Q8*R8 (Error #VALUE! when R8 = error). Each column is totalled with =SUM. Any thoughts?

**MarvinP** · 08-14-2012, 11:37 PM

Hi TPS and welcome to the forum,

It sounds like you need to learn the ISERROR function in Excel. Read http://www.excel-examples.com/iserror.htm
Note - In 2007 Excel there is a newer IFERROR function that is cleaner than the older 2003 ISERROR function.

**Al Chara** · 08-14-2012, 11:38 PM

One way to do it is with Conditional Formatting. In Excel 2010, select the range of cells, then add a New Rule under Conditional Formatting. Select "Use a formulas to determine which cells to format". With all the cells selected add the formulas =ISERROR(A1) and select the white font color format.