Coffeehouse Thread

44 posts

850 * 77.1 is 65535... unless you're Microsoft Excel.

Back to Forum: Coffeehouse
  • User profile image
    Cannot​Resolve​Symbol

    Image Hosted by ImageShack.us

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

    (see also this thread)

  • User profile image
    Sven Groot

    bizarre!

  • User profile image
    Rossj

    Reading through the linked thread it seems to be a result of pre AND post processing of the value before it is rendered. The fact that A1-1 and A1+1 (where A1 is the SUM()) give different results lend some weight to this argument.

  • User profile image
    cheong

    Banks using Excel to handle money shall have sleepless nights if upgraded to Excel 2007.

    They should have busy time verifying the balance of accounts... Tongue Out

    Recent Achievement unlocked: Code Avenger Tier 4/6: You see dead program. A lot!
    Last modified
  • User profile image
    JonesJ

    As a front office developer at an investment bank this scares the crap out of me.

    MS fix this and fix it VERY quickly!!!

  • User profile image
    BlackTiger

     Cool Cool CoolTongue Out Tongue Out Tongue Out

    MS KNOWS BETTER!!!

    Bloody hell!!! HOW?!?!?!?!


    PS: "=IF(77.1, 77.0999)" rulezzz!

    PPS: Never do any development/testing in India/China...

    If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
    Last modified
  • User profile image
    Bas

    BlackTiger wrote:


    PPS: Never do any development/testing in India/China...



    What does this have to do with anything?

  • User profile image
    BlackTiger

    JonesJ wrote:
    

    As a front office developer at an investment bank this scares the crap out of me.

    MS fix this and fix it VERY quickly!!!



    Don't think so.... Now MS needs to check ALL operations for ALL numbers... Cool

    If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
    Last modified
  • User profile image
    BlackTiger

    Bas wrote:
    
    BlackTiger wrote:


    PPS: Never do any development/testing in India/China...



    What does this have to do with anything?


    Oh, sorry! I've completely forgot!
    "Quality" doesn't means anything anymore, just "quantity"...

    PS:
    "QoS":
    1. (old meaning) "Quality of Service"
    2. (new maning) "Quantity of Sold"

    If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
    Last modified
  • User profile image
    BlackTiger

    But wait...

    Perhaps Excel using some elements of quantum calculations?...
    Probably in some parallel universe 2x2 is not quite 4? Who knows...

    If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
    Last modified
  • User profile image
    Bas

    BlackTiger wrote:
    
    Bas wrote:
    
    BlackTiger wrote:


    PPS: Never do any development/testing in India/China...



    What does this have to do with anything?


    Oh, sorry! I've completely forgot!
    "Quality" doesn't means anything anymore, just "quantity"...


    At the risk of channeling SirHomer: Perplexed

  • User profile image
    YearOfThe​LinuxDesktop

    excel-lent! [6]

  • User profile image
    evildictait​or

    cheong wrote:
    Banks using Excel to handle money shall have sleepless nights if upgraded to Excel 2007.

    They should have busy time verifying the balance of accounts...


    Goldman sachs never upgraded from 98...

  • User profile image
    harumscarum

    that cant be good. Did you just randomly stumble on this?

  • User profile image
    figuerres

    CannotResolveSymbol wrote:
    Image Hosted by ImageShack.us

    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.

  • User profile image
    tribalcactus

    There has already been a bug filed on this.  My guess is that it will be addressed with SP1.

  • User profile image
    Minh

    Settle down. This is just part of MS Do More With Less campaign. You will now be able to do 100,000 with just 65,355. Quit complaining!

    PS
    This does look like somebody forgot to take out some debugging code, though. 65355 = 2^16 - 1  (or (Int16) -1)

  • User profile image
    BlackTiger

    Ok...

    MS Stats:

    Units of Vista sold: 850
    Unit Price, GBP: 77.1
    Sale Amount, GBP = 100,000

    Yo!
    Cool

    If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
    Last modified

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.