Jump to content
Logo
Comments
Hmmm...Mine Works...

My Excel 2003 has 850*77.1 equaling 65,535. Might already be patched?!?!

posted by : Tweak, 25 September 2007Complain about this comment
That's because

The article is talking about Excel 2007 you numpty.

posted by : Olaf, 26 September 2007Complain about this comment
Confirm

Wao, this will be the best bug, hopefully they can fix it in SP1. I have try multiply 850 by 77.1 in Excel 2007 + Autopathcer Office 2007 August 2007 and still got the 100.000.

posted by : Hok, 26 September 2007Complain about this comment
Read again...

If you read the article carefully, they are talking about Excel 2007

posted by : Catalin, 26 September 2007Complain about this comment
Excel Limit ?

Excel rows end on the very next number 65536 - wonder if thats got something to do with it

posted by : Raj, 26 September 2007Complain about this comment
Interesting

It seems Excel 2007 also can't calculate 840*78.0178571428571428571428571428571 but correctly reports 65535 for 840*78.017857142857142857142857142857 (dropping the last decimal). Evidently the bug is smart enough to affect only calculations that produce "exactly" 65535.

posted by : Jonathan, 26 September 2007Complain about this comment
Is it a display thing

when you calculate 850 * 77.1 and then from the result subtract 2 you get what looks like... 1000000 - 2 = 65533...

posted by : Teach, 26 September 2007Complain about this comment
16 bit binary

"65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number." http://en.wikipedia.org/wiki/65535_(number)

posted by : joebloggsy, 26 September 2007Complain about this comment
It does work

And if you multiply 77.1*850 you get 5052748.5. Put 850 in on cell (A) and 77.1 in another (B). Try A*B and B*A.

posted by : Dede, 26 September 2007Complain about this comment
2 to the 16th overflow?

This is a freshman year programming mistake. Is quality control so lacking at Microsoft these days that they don't even test for overflows?

posted by : raboof, 02 October 2007Complain about this comment
Actually...

@Raj: Actually, in Excel 2007, rows end at 1,048,576.

posted by : Evan, 05 November 2007Complain about this comment

Excel goes nuts at 65,535

Advertisement
Subscribe to the INQ Newsletter
Sign-up for the INQBot weekly newsletter
Click here to sign up Existing user
Advertisement
INQ Poll

Consumer Electronics Show

CES 2009 shrinks through lack of interest