#DIV error

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

 

[Pete_UK]

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

 

[Zaidy036]

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.

If(c2=0,"",b2/c2)

 

[ss]

If(c2=0,"",b2/c2)

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%

 

[Victor Delta]

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%

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

V

 

[ss]

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

V

Thank you, that now works.