Oops... 9/25/2007 7:24:00 AM
Note to self: If I ever find a time machine, send this list to the Excel 2007 team before they ship.

=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

+ Comment
Dave Wow that's a good one. I thought this would just be demonstrations of floating point math producing results inconsistent with real math. But how do you accidentally get 100000 instead of 65535? Granted 65535 is a special number but where does 100000 come from? Try '=65535*2/2' and '=65535*2.1/2.1'
Dave Err... 1.1 not 2.1 above
Chris Hmmm, they (http://blogs.msdn.com/excel/) say its a display issue and the calculation is really working on the backend.
Eric Phew, that's a relief. It just ~looks~ like a bug. :-)


< Eric's Blog Home


©1998-2020 Eric Lawrence