is there a way to turn off the display of an error message

i have a workbook setup that have several pages in it (for a month) and some
math where a cell that may not be filled in yet is a 0 value.

so i am getting lots of divide by zero errors. it certainly is useful to
know but detracts from the appearance. can this selectively be turned off?

thanks.

jim

Hi Jim!

There's different ways of approaching this.

Try amending the formulas that resolve to the error:

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

This returns an empty looking cell until a numeric entry is made to
B1. But note that it will return #VALUE! if text is input to B1. This
is probably more desirable than the alternative:

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

This returns an empty looking cell until a numeric entry is put in B1
but also returns an empty cell if some darned fool puts text in B1.

As a general rule you should hide specific (acceptable) errors rather
than just hide all errors.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Assume your formula is +A1/B1 and B1 is the errant cell providing the
zeros.......

Maybe..........

=IF(ISTEXT(B1),"",IF(B10,A1/B1,""))

(will also accomodate text in B1, but does not accomodate negative numbers)

Vaya con Dios,
Chcuk, CABGx3





"jim sturtz" wrote in message
...
i have a workbook setup that have several pages in it (for a month) and
some
math where a cell that may not be filled in yet is a 0 value.

so i am getting lots of divide by zero errors. it certainly is useful to
know but detracts from the appearance. can this selectively be turned
off?

thanks.

jim

thanks guys.

jim