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

  • Vendors Update Controls for .NET Core 3.1, Blazor

    This week saw two third-party vendors of dev tools -- UX and UI toolkits and controls -- release new offerings that include support for two of Microsoft's main open source frameworks, the cross-platform .NET Core 3.1 and Blazor, which allows for creating browser-based web applications with C# instead of JavaScript.

  • C++ Is Focus of New Visual Studio 2019 v16.7 Preview 2

    C++ development is a focus point of the new Visual Studio 2019 v16.7 Preview 2, featuring a slew of tweaks and improvements touching upon remote SSH connections, IntelliSense support and more.

  • Clustering Non-Numeric Data Using C#

    Clustering non-numeric -- or categorial -- data is surprisingly difficult, but it's explained here by resident data scientist Dr. James McCaffrey of Microsoft Research, who provides all the code you need for a complete system using an algorithm based on a metric called category utility (CU), a measure how much information you gain by clustering.

  • So What's Up with Microsoft's (and Everyone Else's) Love of Rust?

    Microsoft already stewards several popular programming languages -- C#, TypeScript, F# -- so what's up with its love of Rust, along with the rest of the world?

  • C# Steps Up Programming Language Popularity Ladder

    Microsoft's C# programming language climbed a year-over-year notch on the TIOBE Index, which measures popularity among developers.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events