Using Excel 2003, if I sum the following numbers :
-423,418.15
-144,349.60
-38,959.80
-23,122.30
-82.90
31,225.79
2,375.00
10,160.83
15,416.67
22,145.83
11,850.00
6,442.08
10,845.52
25,411.50
12,535.43
5,333.35
49,819.10
18,882.17
13,394.26
13,823.57
6,890.83
7,307.50
41,250.00
13,900.91
5,698.08
13,771.68
11,622.50
4,334.16
7,633.34
5,916.66
20,647.49
39,471.96
9,474.72
14,963.33
11,333.33
6,201.67
12,333.34
3,916.67
6,638.34
2,703.84
5,916.67
3,025.66
15,583.34
3,166.68
3,407.05
5,041.67
2,400.00
1,954.17
8,015.72
5,615.40
2,333.34
10,833.33
873.00
2,566.50
13,833.33
5,911.66
3,545.21
18,153.95
21,049.04
145.55
6,325.79
-2,347.75
-228.00
-98.75
-1,569.00
468.72
117.18
346.84
-4,000.00
1,875.00
I get a result of -2.30556906899437E-10!! I have copied them into notepad, and then copied them back in to clear all formatting, but I am still getting this bizarre result? I have tried them in different spreedsheets, I have manually inputted them.
Help!
Bookmarks