Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 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 29 Times in 29 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
  •