Excel question.
 

How do I eliminate #div/0 in the total cell of averages?

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?

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