well, it was just an idea........ i didn't know you had zillions of
formulas connected all together.
i guess the one that looks at whether or not it's empty is the best.
but that's going to also trigger issues all the way down your
formulas, maybe, because there won't be 0 but it'll be blank.
:D
susan


On May 23, 2:37 pm, Harlan Grove wrote:
Susan wrote...
another idea is to leave the formula as it is, and use conditional
formatting to turn it to white text if it's an error..........

formula is if(iserror(c19/c18))
format white text

then it'll automatically be "invisible" when people open the
spreadsheet, but when they start entering info into column c then
suddenly the formula will "appear".

:)

...

But if the formulas producing the #DIV/0! errors are used in other
formulas, those other formulas would also have to be conditionally
formatted. And if those other formulas were called by yet other
formulas, those other formulas would also have to be conditionally
formatted. And so on.

Bummer.
:(

but that's going to also trigger issues all the way down your
formulas, maybe, because there won't be 0 but it'll be blank.

That's possible *BUT* dealing with formula blanks is much easier than
dealing with error values.

Biff

"Susan" wrote in message
s.com...
well, it was just an idea........ i didn't know you had zillions of
formulas connected all together.
i guess the one that looks at whether or not it's empty is the best.
but that's going to also trigger issues all the way down your
formulas, maybe, because there won't be 0 but it'll be blank.
:D
susan


On May 23, 2:37 pm, Harlan Grove wrote:
Susan wrote...
another idea is to leave the formula as it is, and use conditional
formatting to turn it to white text if it's an error..........

formula is if(iserror(c19/c18))
format white text

then it'll automatically be "invisible" when people open the
spreadsheet, but when they start entering info into column c then
suddenly the formula will "appear".

:)

...

But if the formulas producing the #DIV/0! errors are used in other
formulas, those other formulas would also have to be conditionally
formatted. And if those other formulas were called by yet other
formulas, those other formulas would also have to be conditionally
formatted. And so on.

Bummer.
:(