#DIV/0! error
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
---------------
Jacob Skaria
"bubbles1956" wrote:
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))
"Jacob Skaria" wrote:
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?
|