#DIV error

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

When I divide one cell by the other if the answer is zero I get #DIV/0
error. Previously (I just do simple spreadsheets) I just done a
conditional format if no. was less than 0 then format text in white so
it (error) didnt show up but for some reason this isnt working for me. I
seem to recall there was another method by adding something to the
formula. The formula is simple like =B2/C2
Can anyone help please.
 
Change your formula to this:

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

Then you will just get a blank instead of the error.

Hope this helps.

Pete
 
ss said:
When I divide one cell by the other if the answer is zero I get #DIV/0
error. Previously (I just do simple spreadsheets) I just done a
conditional format if no. was less than 0 then format text in white so it
(error) didnt show up but for some reason this isnt working for me. I
seem to recall there was another method by adding something to the
formula. The formula is simple like =B2/C2
Can anyone help please.
Click to expand...

If(c2=0,"",b2/c2)
 
If(c2=0,"",b2/c2)
Click to expand...

Ok still having a problem which maybe to do with having the cell
formatted to %.
I2= 1000 J2= 4000 L2= 0%
Formula used =IF(L2=0,"",I2/J2)
The answer I get is 0% when it should be 25%
 
ss said:
Ok still having a problem which maybe to do with having the cell formatted
to %.
I2= 1000 J2= 4000 L2= 0%
Formula used =IF(L2=0,"",I2/J2)
The answer I get is 0% when it should be 25%
Click to expand...

Your formula (in L2) should be =IF(J2=0,"",I2/J2). Then it works perfectly!

V
 
Back
Top