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.
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.