Why does Excel INT(x) behave like ROUND(x,0) for 10^14 andhigher?
On Jan 18, 12:02*pm, Jerry W. Lewis
wrote:
WAG as to what MS was thinking: If you ask Excel to round a number, you
probably will evaluate its [behavior] based on what you can see (documented
15 digit limit). *Why they extend that thinking to INT, TRUNC, etc is a
mystery.
And even more of a mystery since, as you say, 1E+14+0.5 is not even
displayed as 100000000000001 (if I counted the zeros correctly <g) in
Excel 2003, when formatted as Number.
BTW, I should have noted that I am, indeed, using (Office) Excel 2003.
Anyway, thanks for your comments. I was hoping that you, especially,
would have an answer for me. Oh well....
|