Excel 2007 calculation bug

You probably already know about this but it’s such an egregious failure that I feel I have to post something about it. Excel 2007 sometimes has problems with the result of calculations in the range of 65,534.99999999995 to 65,535 and 65,535.99999999995 to 65,536. Excel can display the value as ” 100,000 ” instead of the proper value. Microsoft’s working on a fix but I haven’t seen anything so far. This week’s Office Watch newsletter has a decent write-up of it. It’s an email newsletter but a rundown of the failure is available at this link on their news site.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: