03 October 2007

Excel2007 makes mistakes!

Try multiplying 77.1 by 850 in Excel2007. Should be 65535. Microsoft seem to think it should be 100000. In fact any multiplication that should give an answer of either 65535 and 65536 goes wrong. Weird! I would be interested to know of any other odd 'answers'. Microsoft are to issue a patch for this particular one but who knows what others remain?

No comments: