#DIV/0! error
 

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?

#DIV/0! error
 

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?

#DIV/0! error
 

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?

#DIV/0! error
 

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?

#DIV/0! error
 

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

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

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?

#DIV/0! error
 

Oops the below is a wrong post
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

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

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?

#DIV/0! error
 

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?

#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?