Oops..In Cell BN3

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

If this post helps click Yes
---------------
Jacob Skaria


"bubbles1956" wrote:

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.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"bubbles1956" wrote:

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?