Excel wont display a zero when dividing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help! I am making a database that gives an average of a 6 period time
frame. The problem is that when excel grabs the numbers from sheet 1 to
import to sheet 2 for the average %, if the column does not have characters
in both areas of the chart excel displays the error message #DIV/O! I know
you can not divide by zero but I still need the average % to be displayed. I
have tried the average, daverage, the if function. Someone please shed some
light on this for me. How do I trick excel not to display the error message
and give my a 0%??
 
smiles said:
Please help! I am making a database that gives an average of a 6 period time
frame. The problem is that when excel grabs the numbers from sheet 1 to
import to sheet 2 for the average %, if the column does not have characters
in both areas of the chart excel displays the error message #DIV/O! I know
you can not divide by zero but I still need the average % to be displayed. I
have tried the average, daverage, the if function. Someone please shed some
light on this for me. How do I trick excel not to display the error message
and give my a 0%??
Click to expand...

Something like this should work:

=IF(ISERR(B1/C1),0,B1/C1)

Whenever C1=0, B1/C1 will result in an error. This Error will cause
the IF statement to evaluate to TRUE which will result in a 0 being
evaluated. For all other cases, the cell will show the value of B1/C1.

Just plug in the cell values that apply to you and this should work.
 
OMG!!!!!!! Thank-you sooooo much, I really appreciate your help!!! If you are
ever in Yuba City we will gladly take you out to lunch and coffee!!!!! Please
contact me if you ever need anything!!!!!!!!!

THANK YOU!!!!!!!!!!!!!!!!!!
April
 
"Mark"

I have a new question for you, my new friend, in this workbook, we need to
be able to take the data entered into the corresponding fields to create a
interactive chart. I need the chart to be capable of looking at say the past
4weeks of information. My boss would like to be able to pick and choose what
the chart displays at any given time, does this make sense? For example, If I
wanted to go look at the information from period (which is 2 weeks) 1 and 2
how would I get the chart to display this information at will, so I or a
'clerk' is capable of pulling up this information to change the data
reflected in the graph.
 
"Mark"

I have a new question for you, my new friend, in this workbook, we need to
be able to take the data entered into the corresponding fields to create a
interactive chart. I need the chart to be capable of looking at say the past
4weeks of information. My boss would like to be able to pick and choose what
the chart displays at any given time, does this make sense? For example, If I
wanted to go look at the information from period (which is 2 weeks) 1 and 2
how would I get the chart to display this information at will, so I or a
'clerk' is capable of pulling up this information to change the data
reflected in the graph.
Click to expand...

I wish I could be more helpful, but charts and graphs are something I
rarely use in Excel. As a result, I can offer little or no better help
than you would be able to read for yourself in the Help files. Try
reposting this question here and in the "Microsoft Public Excel"
newsgroup. I am sure someone will be able to help you.

Happy Hunting....
 
Back
Top