Huge multiplication bug in Microsoft Excel 2007

[Chasing_Dreams]

From the news sites I read, I have found out that there is a huge multiplication bug in Microsoft Excel 2007. This Google Group provides the bread and butter of the problem. To summarize, there is a large set of two numbers that when multiplied together should give 65 535. However, Excel shows these results as 100 000!.

Try it out, open Excel 2007 and try some of these combinations and then check them with a calculator:

=5.112850
=10.26425
=20.43212.5
=40.81606.25
=77.1850
=154.2425
=212.5308.4
=308.4212.5
=425*154.2

I wouldn’t use Excel 2007 for anything critical until a patch is issued.

[if6was9]

I don’t have Excel 2007. I just find it ironic that I used Bill’s calculator to check your numbers… and they all worked. Of course re-writing that particular (mundane) piece of code was probably a better idea… :rolleyes: