# Excel adding numbers wrong ?

This is a discussion on Excel adding numbers wrong ? within the Excel Questions forums, part of the Question Forums category; Why is Excel adding the numbers wrong ? The true answer is 7,274.87, but AutoSum is giving me 7,274.89 or ...

1. ## Excel adding numbers wrong ?

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 ?

******** ******************** ************************************************************************>
 Microsoft Excel - Book2.xls ___Running: 11.0 : OS = Windows XP
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 A38 =

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

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

2. Are these numbers values or the results of formulas?

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

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

******** ******************** ************************************************************************>
 Microsoft Excel - Book2 ___Running: 11.0 : OS = Windows Windows 2000
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 A38 =

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

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

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

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

6. Make sure all your numbers are values??

Michael

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

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

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

******** ******************** ************************************************************************>
 Microsoft Excel - Book2.xls ___Running: 11.0 : OS = Windows XP
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 A38 =

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

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

10. 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([formula],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.

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•