Hacker News new | ask | show | jobs
by hulitu 1338 days ago
... until all your numbers become dates.
4 comments

Or all your zip codes with leading zeros get silently truncated.
Or until all your 16 digit IDs get truncated...
... or until all your molecules become dates.
Why do I remember awk with that story?
Or your numbers are wrong because you didn't wrap in parentheses.

Example, put these two formulas in excel:

=(4/3 - 1)*3 - 1

=((4/3 - 1)*3 - 1)

The online version, at least, seems to be wrong when you do wrap it in parentheses:

=(4/3 - 1)*3 - 1 = 0

=((4/3 - 1)*3 - 1) = -2.22045E-16

Check out page 3-5 of this paper called How Futile are Mindless Assessments of Roundoff in Floating-Point Computation? [0]. It explains what is happening here better than I can and is where I got this example from.

[0]: https://people.eecs.berkeley.edu/~wkahan/Mindless.pdf

Or until your empty cells aren't truly empty, so you can't count the nonempty cells.
That reminds of a jokester who replaced all empty cells in small spread sheet with a space. Good lick figuring out why your 5 row table all of a sudden was in the giga bytes of size (obvious exageration for dramatic reasons). Was a good practical joke so!