Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,536
    Thanks
    38
    Thanked 68 Times in 64 Posts

    Error in 2007 (2007)

    Has anyone heard an official MS position on how this will be fixed?

    A Big Excel Boo-Boo

    A mathematical bug in Microsoft Excel 2007–an inability to multiply that makes the 1998 Intel-chip math bug look like a warm-up act.

    It turns out that when you multiply certain numbers that SHOULD equal 65,535… Excel gets 100,000.



    Like this one: 850*77.1 =

    or these:

    5.1*12850 =
    10.2*6425 =
    20.4*3212.5 =
    40.8*1606.25 =
    77.1*850 =
    154.2*425 =
    212.5*308.4 =
    308.4*212.5 =
    425*154.2 =

    (The problem doesn’t seem to exist in other versions, like Excel 2000 or Excel for Macintosh.)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 30 Times in 30 Posts

    Re: Error in 2007 (2007)

    See the earlier thread <post:=667,371>post 667,371</post:> and the link posted there by Pieterse.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •