#DIV error

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

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
 
Z

Zaidy036

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.

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

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%
 
V

Victor Delta

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%

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

V
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#div/0! 4
divide by zero error 4
Conditional format to cells containing a #DIV/0! error 5
Subtracting 37 hours from a cell containing format [h]:mm 2
#DIV/0! 5
Div 0 help 1
error #DIV/0! 7
#div/0! error 5

Top