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
=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: Excel
1 Comments:
i have tried it myself..and the answer is not really correct. I think this is a major bug..hopefully Microsoft will solve this problem..tsk tsk..
Post a Comment
Subscribe to Post Comments [Atom]
<< Home