1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel 2010 Sum Function issue

Discussion in 'Other PC Software' started by SUPPO, 2010/12/12.

  1. 2010/12/12
    SUPPO

    SUPPO Inactive Thread Starter

    Joined:
    2010/12/12
    Messages:
    1
    Likes Received:
    0
    I am having some issues with the SUM function in Excel 2010.

    I am trying to SUM the following:

    F11: 500
    F12: 500
    F13: 37.22
    F14: -1037
    F15: -.22

    when i use the formula =F11+F12+F13+F14+F15 and when I use the formula =SUM(F11:F15) I get the following result: 0.0000000000000272837308301632000000000

    I have all cells formatted as a number. Anyone have any thoughts on what is going on here? would seem like pretty straight forward math. this random decimal error doesn't make any sense at all.

    any thoughts or insight would be appreciated.
     
    Last edited: 2010/12/12
    SUPPO,
    #1
  2. 2010/12/12
    BurrWalnut

    BurrWalnut Well-Known Member Alumni

    Joined:
    2003/03/05
    Messages:
    628
    Likes Received:
    8
    If you set all the fields to 2 decimal places, the result will be 0 (zero).
     
    BurrWalnut,
    #2


  3. to hide this advert.

  4. 2010/12/12
    wildfire

    wildfire Getting Old

    Joined:
    2008/04/21
    Messages:
    4,649
    Likes Received:
    124
    To expand on BurrWalnut's solution, it's impossible for a processor to store an exact float number (without exceedingly large overheads) and there will always be a margin of error. In your case do you really need results in excess of 13 decimal places?
     
    wildfire,
    #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...