Why is Excel adding the numbers wrong ?
The true answer is 7,274.87, but AutoSum is giving me 7,274.89 or 2 cent more.
I tried accounting, currency, general and number formatting and it's still adding it wrong, or what am I doing wrong ?
I added it in calculator in Windows and regular calculator and I get the .87 not .89, what could be wrong ?
Please help.
The true answer is 7,274.87, but AutoSum is giving me 7,274.89 or 2 cent more.
I tried accounting, currency, general and number formatting and it's still adding it wrong, or what am I doing wrong ?
I added it in calculator in Windows and regular calculator and I get the .87 not .89, what could be wrong ?
Please help.
Book2.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 438.64 | |||||
2 | 38.85 | |||||
3 | 38.85 | |||||
4 | 38.85 | |||||
5 | 38.85 | |||||
6 | 38.85 | |||||
7 | 38.85 | |||||
8 | 38.85 | |||||
9 | 64.15 | |||||
10 | 38.85 | |||||
11 | 17.62 | |||||
12 | 91.39 | |||||
13 | 3393.11 | |||||
14 | 196.07 | |||||
15 | 803.75 | |||||
16 | 102.23 | |||||
17 | 159.40 | |||||
18 | 53.27 | |||||
19 | 53.27 | |||||
20 | 53.27 | |||||
21 | 55.99 | |||||
22 | 53.27 | |||||
23 | 58.71 | |||||
24 | 53.27 | |||||
25 | 53.27 | |||||
26 | 53.27 | |||||
27 | 53.27 | |||||
28 | 53.27 | |||||
29 | 53.27 | |||||
30 | 53.27 | |||||
31 | 53.27 | |||||
32 | 53.27 | |||||
33 | 53.27 | |||||
34 | 53.27 | |||||
35 | 53.27 | |||||
36 | 53.27 | |||||
37 | 677.42 | |||||
38 | 7274.89 | |||||
Sheet1 |