Excel adding numbers wrong ?

[RompStar]

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.

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

 

[Norie]

Are these numbers values or the results of formulas?

When I copy them into Excel I get the correct result for the sum.

 

[Scott Huish]

Are the numbers in the cells you're adding up rounded? Because as straight numbers, they add up fine:

Book2
	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.4
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.87
Sheet1

 

[RompStar]

How do I check for number rounding, it's probably just me, need to learn this one :- )

 

[daniels012]

What version of Excel?? I use Excel2000 and it works fine.
Michael

 

[daniels012]

Make sure all your numbers are values??

Michael

 

[RompStar]

I use Excel 2003, they are Values, I highlighted them, Copy and Pasted them as Values and number formats.

 

[Scott Huish]

Change the number format to General, now what numbers are they?

 

[RompStar]

I highlighted the whole column, Formatted it as General, here you go, same results:

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

 

[noodle]

keep adding decimal places. when this happens to me i usually find that what i thought was 27.05 was actually 27.05000354, or something along those lines.

if they are results of formulas you can round them to 2 decimal places using

=round(,X) where X is the number of decimal places (in your case 2). edit: just read prooperly... not formula results... but try extending the decimal in any case.