Weird Excel Math Issue

Discussion in 'Software for Windows' started by sswingle, Nov 19, 2012.

  1. sswingle

    sswingle Diamond Member

    Joined:
    Mar 2, 2000
    Messages:
    7,111
    Likes Received:
    1
    Ok, so I have an equation in J14, which is

    =(A4+A10-A2-A8)/2

    A4 is 15.15, A2 is 15.00 A10 is 25.47, A8 is 25.00

    These 4 values are set as currency, 2 decimal points.

    The resulting answer is 0.31. As it should be.

    But then I want to take J14*1704 which should be 528.24.
    However Excel is giving me 522.92

    If I remove the equation from J14 and manually enter 0.31 excel gives me the proper answer of 528.24. Put the equation back in, and even though the cell still says 0.31, it gives me 522.92.

    Any guesses as to what is going on?

    Excel 2007 BTW
     
  2. Loading...

    Similar Threads - Weird Excel Math Forum Date
    Excel formula acts weird after exporting sheet from Google docs. Software for Windows Oct 26, 2008
    Excel 2003 calculation weirdness Software for Windows Oct 22, 2007
    Weird Excel Problem .. Cany anyone help?? Software for Windows Aug 6, 2007
    Weird cut and paste problem with Excel/Photoshop Software for Windows Feb 10, 2007
    Excel weirdness - arrow keys don't change selected cell anymore Software for Windows Oct 9, 2005

  3. Zorander

    Zorander Golden Member

    Joined:
    Nov 3, 2010
    Messages:
    1,132
    Likes Received:
    1
    No such issue here.

    One or more of those 4 fields must be more than 2 decimals. Setting them as currency simply displays them as such. It does not actually change their digit structure. Copy and paste (value) them into other cells (General format) and you should see which ones have more than 2 decimal places.
     
  4. Albatross

    Albatross Platinum Member

    Joined:
    Jul 17, 2001
    Messages:
    2,340
    Likes Received:
    1
    I think it`s a famous Excel bug with floating point multiplication,try updating Office maybe?
    Or make it display more decimals places,I suspect that.31 might be .3178728582blabla or .3054124bla.
     
    #3 Albatross, Nov 20, 2012
    Last edited: Nov 20, 2012
  5. BrightCandle

    BrightCandle Diamond Member

    Joined:
    Mar 15, 2007
    Messages:
    4,763
    Likes Received:
    0
    There is a rule in programming that says that if you think Select is wrong then you are wrong.

    Excel is definitely not getting the maths wrong, its simply impossible. I suspect the number is formatted to less decimal places or something else is off.
     
  6. cl-scott

    cl-scott ASUS Support

    Joined:
    Jul 5, 2012
    Messages:
    457
    Likes Received:
    0
    I just tried it with Excel 2010, and got the correct answer. So there's something else going on, probably with one of your formulas.
     
  7. IronWing

    IronWing Lifer

    Joined:
    Jul 20, 2001
    Messages:
    45,550
    Likes Received:
    2,110

    This. (528.24-522.92)/1704 = 0.003122 which would get rounded off in a 2 decimal display.