hiding #DIV/0! message

G

GJR3599

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)?
 
B

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)
 
T

TxShane

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.
 
J

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
 
Top