In all likelihood, the cells are just formatted differently, so that 4.01818
is *appearing* as 4. In one of these 'wrong' cells, try Format Cells
Number and change the decimals. Does that now show the answer you expect?

"lana1916" wrote:

I am averaging columns with varying numbers (1-5). There are no blanks and no
zeros. When I average some columns, the correct answer comes out with five
decimal places. When I try to average other rows I get a number without
decimal places (such as 4 or 5), but when I do the math physcially, I get the
answer 4.01818 or 4.75... instead of 4 or 5. Why am I getting the wrong
averages on some columns, I am using the same function (the Average function
under the Sum button on the toolbar)?
Please help me as there are many many numbers to average.
Thank you,
Lana