#DIV/0! error

B

bubbles1956

My formula in BN3 is this: =BL3/SUM(BL$3:BL$809)*100
In BL3 there is a 0
How do I get this error to a 0 so it doesn't mess up the rest of my formulas?
 
J

Jacob Skaria

Use a IF() condition like below

=IF(SUM(BL$3:BL$809)=0,0,BL3/SUM(BL$3:BL$809)*100)

If this post helps click Yes
 
B

bubbles1956

The 0's are in BL3 but the =BL3/SUM(BL$3:BL$809)*100 formula is in bn3
I get the DIV error and it carrys over to another cell. I tried that If
condition but I kept getting errors and to be honest, I don't know enough
about the IF statement to know what I might have done wrong.
 
J

Jacob Skaria

Oops..In Cell BN3

=IF(BL3=0,0,BL3/SUM(BL$3:BL$809)*100)

If this post helps click Yes
 
J

Jacob Skaria

Have the range as the text string and use INDIRECT()

=SUM(INDIRECT("B5:B14"))

If this post helps click Yes
 
B

bubbles1956

I am still getting an error in my formula. This is what the formula looks
like when I add the if statement:
=BL3/SUM(BL$3:BL$809)*100+IF((BL3=0,0,BL3/SUM(BL$3:BL$809)*100))
 
J

Jacob Skaria

I see a repetition in your formula. You are trying to add the value again
instead

=IF(BL3=0,0,BL3/SUM(BL$3:BL$809)*100)

If you really want to add then try

=IF(BL3=0,0,BL3/SUM(BL$3:BL$809)*100*2)

If this post helps click Yes
 
Top