Are these numbers values or the results of formulas?
When I copy them into Excel I get the correct result for the sum.
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 ...
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.
******** ******************** ************************************************************************>
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
=
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.
Are these numbers values or the results of formulas?
When I copy them into Excel I get the correct result for the sum.
If posting code please use code tags.
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
=
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.
Office 2007/2010
Code:Function MeaningOfLife() As String Dim meaning As String * 5, LifeExperience, x LifeExperience = Array(177, 176, 188, 190, 189) For x = 4 To 0 Step -1 Mid(meaning, 5 - x, 1) = Chr(255 - LifeExperience(x)) Next MsgBox "Pondering the meaning of existence..." MeaningOfLife = meaning End Function
How do I check for number rounding, it's probably just me, need to learn this one :- )
What version of Excel?? I use Excel2000 and it works fine.
Michael
"It is so nice, to see so many, that know so much"
Using Excel 2007
Make sure all your numbers are values??
Michael
"It is so nice, to see so many, that know so much"
Using Excel 2007
I use Excel 2003, they are Values, I highlighted them, Copy and Pasted them as Values and number formats.
Change the number format to General, now what numbers are they?
Office 2007/2010
Code:Function MeaningOfLife() As String Dim meaning As String * 5, LifeExperience, x LifeExperience = Array(177, 176, 188, 190, 189) For x = 4 To 0 Step -1 Mid(meaning, 5 - x, 1) = Chr(255 - LifeExperience(x)) Next MsgBox "Pondering the meaning of existence..." MeaningOfLife = meaning End Function
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
=
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.
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.
Like this thread? Share it with others