FAQICA: Excel2007 makes mistakes!

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:

Post a Comment

faqica??

Frequently asked questions I can answer. I used to have piles of notes about all sorts of ICT things that I needed for classes but nowadays there doesn't seem to be much of that sort of training so most of the time I'm answering individual questions about how to do this or that. Often I'll reply in an e-mail or scribble something down or just go and show people on the job and it occurred to me that all that one-off effort could be put to better use if I could at least make a list of the ones I remembered, and so here we go.