Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account

# Excel 2007 Bug

### #1 james_8970 Posted 29 September 2007 - 10:45 PM

james_8970

Trusted Tech

• Retired Staff
• 5,084 posts
tibbar66 writes with news of a serious multiplication bug in Excel 2007, which has been reported to the company. The example that first 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."

James
• 0

### #2 Troy Posted 02 October 2007 - 07:19 AM

Troy

Tech Staff

• Technician
• 8,841 posts
Hey look! It's true!
• 0

### #3 james_8970 Posted 02 October 2007 - 11:15 AM

james_8970

Trusted Tech

• Topic Starter
• Retired Staff
• 5,084 posts
yup.
James
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users