Results 1 to 5 of 5

Thread: sum wrong (xp)

  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Ohio
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sum wrong (xp)

    I take a column of numbers with 5 decimal places that on a calculator add up to 100. in excel summing the column adds up to 99.00000. I have tried changing format, copying top a new spread sheet and double checking calculated value and still get only 99 total.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sum wrong (xp)

    There are known bugs in Excel caculations. As an experiment, have you tried to put the values in numerical order from lowest to highest.

    If possible can you attach a cut down version of the workbook so that we can see the issue first hand?
    Jerry

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sum wrong (xp)

    ...and then I thought <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Try :

    1) Tools | Options
    2) Click Calculation tab
    3) Select Precision as Displayed
    Jerry

  4. #4
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sum wrong (xp)

    I think may be the floating point problrm

    Try to use the Round function for your column number as in :

    =ROUND(number,5)

    The number 5 in the formula, was to set the number in 5 decimal places

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: sum wrong (xp)

    How many numbers do you have? That sounds like quite a large rounding error for 5DP.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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