View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
gja63 gja63 is offline
external usenet poster
 
Posts: 4
Default Average function not returning expected result

Thanks to all that replied. I figured out my problem, I was including a
figure in the calculation that was not supposed to be included throwing
everything off.
--
Thanks,
Greg


"David Biddulph" wrote:

You're going to need to show us the exact formula, and the numbers involved.
Are you sure that you haven't got some of the cells as text rather than
numbers? What do you see if you temporarily change the formula from
=ROUND(AVERAGE (number 1,number 2...),2) to
=SUM(number 1,number 2...)?
--
David Biddulph

"gja63" wrote in message
...
I am averaging all the numbers including the zeros. My concern is that
74/25
is 2.96, but Excel return 2.64 as the result
--
Thanks,
Greg


"Jim Thomlinson" wrote:

Are you trying to average all of the values or all of the non-zero
values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal
places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a
calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg