Apparently there is an Excel 2007 Bug that is running rampant. I was informed by this by my coworker today regarding the bug.
The bug: Try entering = 850 * 77.1 in any cell, you'll get a result of 100000 which should have been 65535 (0xFFFF in hexadecimal).
After experimenting further, it seems the bug is a
display bug only since if you do something like this:
in A1, enter 850
in A2, enter 77.1
in A3, enter = A1 * A2 (which will print 100000)
in B1, enter = A3 / 77.1 (this will print 850)
in B2, enter = A3 / 850 (this will print 77.1)
in C1, enter = A3 = 100000 (this will return FALSE)
in C2, enter = A3 = 65535 (this will return TRUE)
To make things a bit more interesting, if you change A1 to = 65535 / 850 and A2 to = 65535 / 77.1, A3 will display the correct result which is 65535.
Weird
Powered by ScribeFire.