Page 1 of 2 12 LastLast
Results 1 to 10 of 11

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. #1
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,184

    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
    66,048

    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
    17,039

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

  4. #4
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,184

    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,162

    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,162

    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,184

    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
    17,039

    Default

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

  9. #9
    Board Regular
    Join Date
    Mar 2005
    Location
    Seattle, WA
    Posts
    1,184

    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

    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.

Page 1 of 2 12 LastLast

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