Excel multiplication bug gets a patch

Last month, we reported on a bug in Microsoft Excel 2007 that causes some multiplications to return erroneous results. The multiplications include 7.1*850, 5.1*12850, and 10.2*6425, and while they’re all meant to return results of either 65,535 or 65,536, Excel 2007 returns a result of 100,000 instead.

As CNet reports, Microsoft has now issued a fix for the problem. The fix is available to download from a posting on the Microsoft Excel blog for both Excel 2007 and Excel Services 2007 in its 32-bit and 64-bit versions. Additionally, Microsoft has published knowledge base articles about the Excel 2007 and Excel Services 2007 bugs. The blog posting says Microsoft is currently in the process of adding the fix to Microsoft Update so it can be automatically installed by Excel users, and the company says the fix will be included in the first service pack for Office 2007.

Comments closed
    • Lord.Blue
    • 12 years ago

    Multiplication is a bit off should be 77.1*850, not 7.1

    • Spotpuff
    • 12 years ago

    A 35 meg patch to fix a multiplication bug? Yeesh.

    • eitje
    • 12 years ago

    that’s LITERALLY the most insane bug i’ve ever seen.

    and – trust me – i’ve built some crazy bugs in my time.

    • StashTheVampede
    • 12 years ago

    Wasn’t the division bug of the old Pentiums the reason why they weren’t named 586 instead?

    • Archer
    • 12 years ago

    EEEEEEEEEEEEExcelleeeeent

    • Kharnellius
    • 12 years ago

    I thought it was a display bug, not a multiplication bug. Can someone get the story right?

      • WildBenchv2
      • 12 years ago

      Its a display bug, though it seems that some functions that take the display value then carry on the error.

      • d2brothe
      • 12 years ago

      Its a bug that results from performing a division operation. The wrong value is reported. Story seems correct to me.

        • Mithent
        • 12 years ago

        It’s not an incorrect result of a calculation though; it’s just that any calculation which happens to result in one of the few erroneous values is displayed incorrectly. The multiplication/division itself is not incorrect and subsequent formulae relying on an affected cell will also be correct, because the underlying value isn’t wrong.

    • morphine
    • 12 years ago

    After some 25 years of computing, finally Microsoft gets the math done right.

      • Mithent
      • 12 years ago

      Well, I think your 1985 copy of Excel 1.0 will do it correctly.. it’s only Excel 2007 that has the display bug.

    • wof
    • 12 years ago

    Wow that bug had to be pretty hard to create 🙂

    • Vrock
    • 12 years ago

    Cool, now I can release that 3rd grader I’ve been keeping in a cage.

      • ssidbroadcast
      • 12 years ago

      Cool, now I can stop using that XO laptop I stole from that guatemalan kid.

    • Usacomp2k3
    • 12 years ago

    Cool 8)

Pin It on Pinterest

Share This