Bug in MS Excel 2007

[Alex Franke]

Believe it or not, in MS Excel 2007, it looks like any floating point calculation resulting in 65536 (2^16) resolves to 100000. Try the formula "=850*77.1".

Or even "=65536 / 850 * 850" -- this resolves to 100001 apparently.

Pretty bad bug if you ask me...

[cgallery]

Interesting. I don't use Excel 07 (so can't try it). But, these types of boundary errors are typically not isolated. It will be interesting to watch this unfold.

FWIW, Office 07 seems to be full of problems. Outlook hogs the CPU while checking for new mail. Excel can take FOREVER to graph stuff that previous versions did in the blink of an eye. There are lots more problems, I just can't remember all of 'em.

[gwyneth]

Shades of the early Pentium floating point error.

But remember, this is the industry where "quality is number 1.01".

[linear]

Seems like a display error--add 1 to "=65536 / 850 * 850" and get the correct result.