Suppressing errors

  • Thread starter Thread starter www.ttdown.com
  • Start date Start date
W

www.ttdown.com

Is there anyway to turn off errors like #Value! or #DIV/O in a
spreadsheet? I have a formula that works when there is data in a cell
that is referenced but when the cell is empty I get the #DIV/O error.
I'd like to suppress the error without using the =IF function. Just
thought maybe there might be some kind of setting that would disable
these types of error messages when I print the spreadsheet.

Thanks!!
 
One trick I like to use that does not require formulas is
to make the font of my entire worksheet white, and then
custom format the entire sheet as:

[Black]General

This will disguise any error values.

HTH
Jason
Atlanta, GA
 
From excel Help File

Format text in cells that contain errors so they don't show

1. Select the cells that contain the error value.
2. On the Format menu, click Conditional Formatting.
3. In the box on the left, click Formula Is.

4. In the box on the right, type =ISERROR(reference), where referenc
is a reference to the cell that contains the error value.
5. Click Format, and then click the Font tab.

6. Click Format.
7. In the Color box, select white
 
Back
Top