Developer's Toolkit

Blog archive

Excel Flunks Basic Math

If you were in IT in 1994, you probably remember Intel's huge Pentium recall because of floating point math errors. The errors seemed tiny on the surface (Byte magazine estimated an error every 9 billion calculations), but a small error carried across a massive set of spreadsheets and other apps equals big, big problems.

Today's Excel has a similar problem but since this is software, not processors, fixing this bug shouldn't cost the $200 million or so that Intel shelled out.

Microsoft says that Excel can produce an error when calculating a problem that should return 65,535 or 65,536 as is its result. Somehow, Excel adds 34,465 (or 34,464) and gives 100,000 as the sum. Weird.

Posted by Doug Barney on 10/01/2007 at 1:15 PM


comments powered by Disqus

Featured

  • Microsoft's Tools to Fight Solorigate Attack Are Now Open Source

    Microsoft open sourced homegrown tools it used to check its systems for code related to the recent massive breach of supply chains that the company has named Solorigate.

  • Microsoft's Lander on Blazor Desktop: 'I Don't See a Grand Unified App Model in the Future'

    For all of the talk of unifying the disparate ecosystem of Microsoft-centric developer tooling -- using one framework for apps of all types on all platforms -- Blazor Desktop is not the answer. There isn't one.

  • Firm Automates Legacy Web Forms-to-ASP.NET Core Conversions

    Migration technology uses the Angular web framework and Progress Kendo UI user interface elements to convert ASP.NET Web Forms client code to HTML and CSS, with application business logic converted automatically to ASP.NET Core.

  • New TypeScript 4.2 Tweaks Include Project Explainer

    Microsoft shipped TypeScript 4.2 -- the regular quarterly update to the open source programming language that improves JavaScript with static types -- with a host of tweaks including a way to explain why files are included in a project.

Upcoming Events