Excel CAN'T ADD!

Discussion in 'Mac Apps and Mac App Store' started by ccalleri, Mar 22, 2008.

  1. ccalleri macrumors member

    Joined:
    Jul 7, 2007
    Location:
    Toronto
    #1
    Check out this problem I am having .. what is the deal??
    The top number has the =sum formula .. IT'S OFF BY 0.01!

    If you take a calculator and add up the column, you get 50.83 NOT 50.82!
     

    Attached Files:

  2. maccompaq macrumors 65816

    maccompaq

    Joined:
    Mar 6, 2007
    #2
    I used your figures in Excel and come up with 50.83.
     
  3. firstapple macrumors 6502a

    firstapple

    Joined:
    Sep 25, 2007
    #3
    Same here... there may be a rounding issue if you have input more then 2 decimals when entering numbers. Excel works fine, I have never had an issue with it calculating anything wrong, and I use it 5 days a week for 40+hours.

    I would say check all the values being summed, and see if anything accidentally has more then two decimals.

    For instance: If you have ten "$0.001's" they will display $0.00 however when you SUM them it will give you a total of $0.01:

    [​IMG]
     
  4. Gerg macrumors regular

    Joined:
    Feb 3, 2003
    #4
    That's usually the case, one of the numbers has more than 2 digits after the decimal, but the formatting only shows 2. It may also be the case that one of the numbers listed is a calculation of something else (or rather, the result of another calculation) and has been rounded to 2 decimal places.
     
  5. MacDawg macrumors P6

    MacDawg

    Joined:
    Mar 20, 2004
    Location:
    "Between the Hedges"
    #5
    Also, you can go into your preferences and "set precision as displayed" and it will take care of the issue, although you will lose the accuracy from the non-displayed decimals.

    Woof, Woof - Dawg [​IMG]
     
  6. herr_neumann macrumors 6502

    herr_neumann

    Joined:
    Mar 27, 2003
    Location:
    Roseville, Ca
    #6
    I ran into some issues with the normdist function while doing some financial modeling, so Excel is not flawless. Actually with the number of firms that use Excel Microsoft should be going through that code with a fine tooth comb, it would be ironic to see them done in by I banks that have used their software instead of a tech company....
     
  7. MacDawg macrumors P6

    MacDawg

    Joined:
    Mar 20, 2004
    Location:
    "Between the Hedges"
    #7
    Did you report your issue to MS, and if so, did you get a response?


    Woof, Woof - Dawg [​IMG]
     
  8. BashBrannigan macrumors newbie

    Joined:
    Mar 23, 2008
    Location:
    Toronto
    #8
    check cell references

    Could be rounding off, but something tells me it might also be the sum formula isn't referencing all the cells.
     
  9. herr_neumann macrumors 6502

    herr_neumann

    Joined:
    Mar 27, 2003
    Location:
    Roseville, Ca
    #9
    I filled out their online feedback form on the mactopia page, but I have heard nothing since.

    -J
     

Share This Page