Why does Excel INT(x) behave like ROUND(x,0) for 10^14 andhigher?
Errata (nitpick)....
On Jan 17, 10:53*pm, I wrote:
10^14 requires only 46 of the 52 mantissa bits.
I meant to say: numbers around 10^14 require only 46 of the 52
mantissa bits;
specifically, 2^46+1 (70368744177665; about 0.7E+14) through 2^47-1
(140737488355327; about 1.4E+14). 10^14 itself requires only 32
bits. Not an important point.
|