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

[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

 

[Norman Harker]

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.

 

[CLR]

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

 

[jim sturtz]

thanks guys.

jim