Quote:
Originally Posted by Alex
65535 is the largest 16-bit number when expressed in base-10. Excel 2007 has a bug in its math engine that sometimes shows up when doing things around that number. It was just found this week I believe (I'm assuming since I've seen it mentioned several times this week all of a sudden).
|
Yup. It's apparently only a display problem, not really a math problem. If you feed the result of such an equation as input to another equation, it works fine. But if your final answer to be displayed is either 65,535 or 65,536 (or apparently within a few decimal places thereof), the engine that converts it into displayable text loses its brains and displays "100,000" as the answer.