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

  • Thread starter Thread starter jim sturtz
  • Start date Start date
J

jim sturtz

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.
 
Assume your formula is +A1/B1 and B1 is the errant cell providing the
zeros.......

Maybe..........

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

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

Vaya con Dios,
Chcuk, CABGx3
 
Back
Top