divide by 0

[bp]

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

 

[Bob Phillips]

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)

 

[Mark Lincoln]

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.)

 

[dodong]

Or you can use this

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

Dodong

 

[bp]

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