Sum help this is puzzling???????????
Scott
I don't get it. I copied/pasted your numbers into excel, came up with 49.607
Tools/Options/precision as displayed not checked.
Formatted as "general"
What formulas are you using to get the number in the column, and what
formula add them for you?
Beege
"scott" wrote in message
...
I have a simple sum problem. I have the following data entered. The sum
total
in excel =49.604
When you add these up it should read 49.607
What the heck is going on?
Scott
1.802
2.337
1.942
1.330
0.885
1.910
1.780
2.927
2.413
2.617
1.297
0.522
2.453
2.582
2.388
1.453
1.751
0.794
0.769
2.170
1.689
2.391
2.007
1.265
1.081
0.821
1.761
2.470
0.000
0.000
0.000
|