Beware multiplication in Excel 2007

B

Bob I

Gordon said:
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
 
Top