| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Linear Mode
