Beware multiplication in Excel 2007

http://www.appscout.com/2007/09/excel_cant_multiply.php

Keep that hand calculator handy.

"Val" <vmanes@NOSPAMrap.midco.net> wrote in message
news:TcqdnaVmJ4kgsGbbnZ2dnUVZ_vihnZ2d@midco.net...
> http://www.appscout.com/2007/09/excel_cant_multiply.php
>
> Keep that hand calculator handy.
>
>


That is REALLY weird - both 850*77 and 850.77.2 give the correct answer -
it's ONLY 850*77.1 that doesn't....

Gordon wrote:

> "Val" <vmanes@NOSPAMrap.midco.net> wrote in message
> news:TcqdnaVmJ4kgsGbbnZ2dnUVZ_vihnZ2d@midco.net...
>
>>http://www.appscout.com/2007/09/excel_cant_multiply.php
>>
>>Keep that hand calculator handy.
>>
>>
>
>
>
> That is REALLY weird - both 850*77 and 850.77.2 give the correct answer -
> it's ONLY 850*77.1 that doesn't....
>
>

No its not weird at all, it's the number 65535 that gets rendered as
100000, the other two expressions don't equal anything near 65535. I
don't have 2007, but try 848.9*77.2