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

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