Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average function not returning expected result
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average function not returning expected result
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average function not returning expected result
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
IF function returning incorrect result | Excel Worksheet Functions | |||
Using sum(1/countif....) not returning expected result | Excel Worksheet Functions | |||
LOOKUP function not returning expected value - Using vector_lookup format | Excel Worksheet Functions | |||
Nested "if" not returning expected value | Excel Worksheet Functions |