Excel adding numbers wrong ?

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Excel adding numbers wrong ?

  1. #1
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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 ?

    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.

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    72,924
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,220
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 2010/365

  4. #4
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    Board Regular daniels012's Avatar
    Join Date
    Jan 2005
    Location
    34 56' 19" N / 82 13' 38" W
    Posts
    5,219
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Board Regular daniels012's Avatar
    Join Date
    Jan 2005
    Location
    34 56' 19" N / 82 13' 38" W
    Posts
    5,219
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure all your numbers are values??

    Michael
    "It is so nice, to see so many, that know so much"

    Using Excel 2007

  7. #7
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  8. #8
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,220
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default

    Change the number format to General, now what numbers are they?
    Office 2010/365

  9. #9
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  10. #10
    New Member
    Join Date
    Jun 2006
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com