Thread
:
Excel Average function not returning expected result
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Excel Average function not returning expected result
It sounds to me as if some of your data may actually be text. If you use
SUM(your range) do you really get 74?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"gja63" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann