in

myITforum.com

Brian Tucker at MyITforum.com

Systems Management and other Items of Interest

Calculation bug in Microsoft Excel 2007

This has evidently been confirmed by Microsoft, and there is a fix on the way.  For more on this, check this link:

 

http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx

 

It appears to be a display only bug, and the calculations are actually correct, but if you look down in the comments, you'll see it gets even more confusing.  Looking at the results below, this gets pretty wierd:

A1 =850*77.1   --> 100000

B1 =A1+1       --> 100001 (realy a display bug???)

C1 =A1-1       --> 65534

D1 =B1-C1      --> 2

 

Anyway, be on the lookout for the fix, because it's in final pass testing!

Comments

 

myITforum Newsletters said:

myITforum Daily Newsletter September 27, 2007 Articles Forums Blogs Wiki FAQs Email Lists In this issue

September 27, 2007 9:09 AM
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems