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…
So the last post was pretty dense, and I haven't used an example since the first post, so I thought I'd throw one out there that you can play with. In what follows, I pretend to use the equations, but I'm actually doing all this in Excel. If you've got Excel, here are some helpful functions.…
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…
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!