One of their flagship products, Excel , has been caught
making errors doing simple multiplication.
href="http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx">According
to a Microsoft Developer blog:
Yesterday evening we were alerted to an
issue in Excel 2007 (and Excel Services 2007) involving calculation of
numbers around 65,535. The first example that we heard about
was =77.1*850, but it became clear from our testing as well as
additional reports that this was just one instance where Excel 2007
would return a value of 100,000 instead of 65,535.
You have to wonder how many interstate-bridge-designing engineers use
Excel.
- Log in to post comments
More like this
I've been getting a lot of requests from people to talk about the recent Excel bug. For those of
you who haven't heard about this, in Excel 2007, floating point calculations that should result in
a number very, very close to either 65,535 or 65,536 are displaying their result as 100,000.
It's only…
Childhood lead poisoning is one of those health risks that everyone has likely heard about, but many probably think it’s a problem of the past. However, a recent study reminds us that in just one state — Michigan — the effects of childhood lead poisoning cost about $330 million every year. And that…
Reaching the hellacious end-of-book period where I do nothing but merge endlessly with my computer. Thus, low on new content. So you can read this stuff instead.
First, check out "Little House in the Ghetto" which will be going on my blogroll just as soon as I figure out how to change my blogroll…
In part I, I wrote about my first semester of teaching on-line and talked about our challenges with technology. Blackboard had a database corruption event during finals week and I had all kinds of struggles with the Windows version of Microsoft Excel. Mike wrote and asked if I thought students…
As I understand it, a clear majority of spreadsheets have errors in them put there by the users, e.g. incorrect formulae. That seems to be a worse thing to worry about!