Coffeehouse Post

Single Post Permalink

View Thread: 850 * 77.1 is 65535... unless you're Microsoft Excel.
  • User profile image

    CannotResolveSymbol wrote:
    Image Hosted by

    More than slightly concerning, considering I trust Excel to do basic arithmetic on a regular basis.

    (see also this thread)

    some kind of display thing....

    I just did 850 * 77 that gave 65,450.000
    then the 850 * 77.100 gave 100,000.000
    when I did =d8-c8 i got 85.00

    but wnen i manualy entered 100,000 and 65,450 and did the subtract i got 34,550.00

    so my off the cuff look says that internally the number is right but the display is wrong.

    but yes MSFT needs to see this and jump on it.