The Inquirer-Home

Excel goes nuts at 65,535

Can't go the maths
Tue Sep 25 2007, 16:02

A THREAD on Google Group microsoft.public.excel reveals that Excel 2007 loses its grip with arithmetic that involves the number 65,535.

Several examples are shown, perhaps the simplest of which is the calculation ( 850 X 77.1 ), which should produce 65,535 but instead returns 100,000.

There's all sorts of speculation as to how this bug occurred, postulating floating-point and rounding errors and the like, but it seems much more likely that some Excel developer simply punted at some point and the Vole's stringent quality control (cough) never caught it.

Some might recall that mathematical errors have been discovered in Excel periodically in various releases going back at least as far as Excel 5.

Microsoft people appear to have been involved in the discussion and confirmed the bug. µ

Google Groups


Share this:

blog comments powered by Disqus
Subscribe to INQ newsletters

Sign up for INQbot – a weekly roundup of the best from the INQ

INQ Poll

Heartbleed bug discovered in OpenSSL

Have you reacted to Heartbleed?