Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel question.
How do I eliminate #div/0 in the total cell of averages?
|
#2
|
|||
|
|||
Eliminate the zero causing this.
If you can't or don't want to do that, consider what you require to calculate. What does an average mean if there are no members? Do you want it to be blank, zero, 16/33rd or one billion? All are equally correct. In general: =IF(Divisor=0,YourAlternative,YourAverageFormula) Or, even worse, =IF(ISERROR(YourAverageFormula),YourAlternative,Yo urAverageFormula)) I don't want to be impolite, but advise you to reconsider the structure of your calculations. In manual calculations, you probably would never try to calculate an average where division by zero is involved. So why try to do it with Excel? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Cmeb4uby" wrote in message ... How do I eliminate #div/0 in the total cell of averages? |
#3
|
|||
|
|||
<All are equally correct
I really meant incorrect, but hardly dare to say. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... Eliminate the zero causing this. If you can't or don't want to do that, consider what you require to calculate. What does an average mean if there are no members? Do you want it to be blank, zero, 16/33rd or one billion? All are equally correct. In general: =IF(Divisor=0,YourAlternative,YourAverageFormula) Or, even worse, =IF(ISERROR(YourAverageFormula),YourAlternative,Yo urAverageFormula)) I don't want to be impolite, but advise you to reconsider the structure of your calculations. In manual calculations, you probably would never try to calculate an average where division by zero is involved. So why try to do it with Excel? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Cmeb4uby" wrote in message ... How do I eliminate #div/0 in the total cell of averages? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Excel chart-y axis title question | Excel Discussion (Misc queries) | |||
Excel Question | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |