PDA

View Full Version : Solved: Excel AutoSum



joms
04-26-2010, 06:45 PM
hi guys, i'm using excel 2007 and one of my users complain that autosum is not working correctly.
Here's the scenario:

3,081.60
42.00
1,070.00
35.00
2,568.00
38.00
903.08
42.00
88.00
189.71
10.00
590.64
total in autosum is: 8,658.02
but if you do it using calculator is: 8,658.03

i tried to take out only the decimal places:
0.60
0.08
0.71
0.64
total in autosum is 2.03 which is correct
but why put in including the whole number total sum becomes 8,658.02 not 8,658.03

actually the difference is point something only but we're doing sales daily if always lacking by point something at the end up of the month it's quite a lot.

any ideas is greatly appreciated?
Thanks.

mbarron
04-26-2010, 08:03 PM
If I autosum using the data you've posted, I get 8,658.03.
I'd guess that there are additional decimal places that are not being displayed but are affecting the rounding.

For example, if you had
3.444
3.444
3.444
it would display as
3.44
3.44
3.44
with a sum showing as
10.33 instead of an expected (based on the displayed values) 10.32

joms
04-28-2010, 02:21 AM
If I autosum using the data you've posted, I get 8,658.03.
I'd guess that there are additional decimal places that are not being displayed but are affecting the rounding.

For example, if you had
3.444
3.444
3.444
it would display as
3.44
3.44
3.44
with a sum showing as
10.33 instead of an expected (based on the displayed values) 10.32 Thanks mbarron, for your reply.
Yup, you are right the rounding function is affecting.