Your Ad Here

September 24, 2007

Excel 2007 Multiplication Bug

tibbar66 writes with news of a serious multiplication bug in Excel 2007, which has been reported to the company. The example first that came to light is =850*77.1 — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. One poster in the forum noted these behaviors: "Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000... =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5."

Read more of this story at Slashdot.

One Response to “Excel 2007 Multiplication Bug”

  1. Rocky Cox Says:

    immiwr5aeml3llgk

Leave a Reply

Helpful Links:

Internal Links:

categories:

search blog:

other:

Blogroll

archives:

September 2007
M T W T F S S
« Aug   Oct »
 12
3456789
10111213141516
17181920212223
24252627282930

Recent Posts:

Stay Up-To-Date With Posts

eXTReMe Tracker

31 queries. 0.831 seconds