If geeks love it, we’re on it

Excel 2007 can’t multiply

Excel 2007 can’t multiply

Excel ’07 chokes on formulas that equal 65,535. What.

Comments

  1. edcentric
    edcentric and this is somehow a surprise to someone?
    Has there ever been a version of excel that didn't do things like this?
  2. Shorty
    Shorty Bug number #10290390290290393 ;D
  3. Linc
    Linc
    Shorty wrote:
    Bug number #10290390290290393 ;D
    It probably errors out on that number too :p
  4. QCH
    QCH Confirmed.... Yep, it's screwed up!!! ;D

    attachment.php?attachmentid=24046&stc=1&d=1190744790
  5. Linc
    Linc I'd be willing to bet it's not a coincidence that 65,535 is 2^16 -1, which is also the max value of a smallint ("small" integer) in several varieties of database software.

    [/geekery]

    //edit: Anyone want to humor me and see if it does anything screwy for values resulting in 16777215? That's the max for medint (2^24 -1). I'm using OpenOffice so I can't test it.
  6. QCH
    QCH 16777216 Works fine for several different equations.

    attachment.php?attachmentid=24047&stc=1&d=1190746236
  7. Thelemech
    Thelemech
    Shorty wrote:
    Bug number #10290390290290393 ;D


    10290390290290393 reasons not to Upgrade :tongue:


    edit:/ and use OpenOffice/StarOffice(GooglePack)/AbiOffice/LotusSymphony etc, etc....

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!