Wednesday, September 26, 2007

MS Excel 2007 can't multiply correctly

Simply when you try to multiply the following numbers in MS Excel 2007!!!

=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=77.1*850
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2
etc...

the answer in Excel 2007 is 10000
but the right answer is 65535


Source: microsoft.public.excel newsgroup

Labels: