divide by 0

hello,
i have a spreadsheet with the same formula down the rows.
some of the rows have data. some are there for future use.
for the empty ones now there is 1 cell that gets #DIV/0!. because of a zero
value.
is there a way to make this show 0 or blank.
i do not want to change the formulas. because if i forget then when i need
to use the row, then data could be messed up.

thanks

Use conditional formatting with a formula of =ISERROR(A1) and set the font
colour to white.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bp" <x@y.com> wrote in message
news:u7yKaiOXGHA.4484@TK2MSFTNGP02.phx.gbl...
> hello,
> i have a spreadsheet with the same formula down the rows.
> some of the rows have data. some are there for future use.
> for the empty ones now there is 1 cell that gets #DIV/0!. because of a
zero
> value.
> is there a way to make this show 0 or blank.
> i do not want to change the formulas. because if i forget then when i
need
> to use the row, then data could be messed up.
>
> thanks
>
>

Let's say your formula is something like:

=B2/C2

If C2 is zero, you'll get an error. Therefore, use an IF to test for
that:

=IF(C2=0,"",B2/C2)

This calculates B2/C2 only if C2 doesn't equal zero. (If you put text
in there you'll get a #VALUE! error, but that's a different subject.)

Or you can use this

=If(iserror(B2/C2),"",B2/C2)

Dodong

"bp" <x@y.com> wrote in message
news:u7yKaiOXGHA.4484@TK2MSFTNGP02.phx.gbl...
> hello,
> i have a spreadsheet with the same formula down the rows.
> some of the rows have data. some are there for future use.
> for the empty ones now there is 1 cell that gets #DIV/0!. because of a
> zero value.
> is there a way to make this show 0 or blank.
> i do not want to change the formulas. because if i forget then when i
> need to use the row, then data could be messed up.
>
> thanks
>
>