hiding #DIV/0! message

[Guest]

how can I make a #DIV/0! message either dissappear, be blank, or appear as a
0.00 (or some other way of making it not look awful on a big spreadsheet)?

 

[Bob Phillips]

=IF(ISERROR(myformula),"",myformula)

or better still, there must be a cell that is dividing into something that
is 0, so test that cell

=IF(A1=0,"",B1/A1)

as an example.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

You can make use of the ISERROR function!

You formula would look something like this:

If(ISERROR(A2/B2)=TRUE, "", A2/B2)

So, you look to see if a cell value produces an error, if it does, it puts a
BLANK, otherwise, it carries out your calculation.

 

[Jason Morin]

Make the font color the same as the background color (if
the cells do not have a background color, set the font to
white) and then custom format as:

[Black]General

HTH
Jason
Atlanta, GA