| 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 |
| 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 | |||
Threaded Mode
