|
||||||||||
|
=5.1*12850 + 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 |