| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel MDI/SDI/Excel Instance to behave more logically | Setting up and Configuration of Excel | |||
| Make Cell behave Like Word | Excel Discussion (Misc queries) | |||
| How do I get filtering to behave consistently? | Excel Worksheet Functions | |||
| Is there a way to count higher than 511 in binary in excel? | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Hybrid Mode
