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. µ
Sign up for INQbot – a weekly roundup of the best from the INQ