On a new sheet type "3.8" in B2, "3.7" in C2 and "=B2-C2" in D2. Does everyone get ".099999" instead of ".1"?
Then use Excel, stop wasting your time on this childish exercise when Excel does what you want it to (in your imagination at least)
if someones car leaks because of this error they are designing incorrectly.
who can machine any metal part to + or - 0.000000000000001 inches or feet or meter?
the diameter of human hair ranges from 17 to 181 µm
0.000000000000001 meters = 1.0 × 10-9 micrometers
that means that a 17um diameter hair is 1,700,000,000 times bigger. This simply falls out of the realm of reasonableness.
I have been an electrical engineer for 22 years and have never, once, needed this kind of precision.
Wayne, I fully expect my car to built to a tolerance of +/- 1 angstrom
Hi jr,
Nothing in life is exact. Least of all, the conversion of 'human' numbers (decimal) to binary and back again to decimal .
https://en.wikipedia.org/wiki/Accuracy_and_precision
As the Australian Bushranger Ned Kelly said: "Such is life."
Regards,
Ian
The problems with the math engine are not being fixed because its easier to shrug your shoulders rather than go back over the issue and fix it.
and to have irregular results is even worse. Play around with multiple number
This is just one of the ones I did.
So the columns on the left were created using previous bucket +.1
On the Right it was a copy and paste values only
Notice the variation on the answer shown as floating -
| 1 | 0.9 | 0.1 | 1 | 0.9 | 0.1 |
| 1.1 | 1 | 0.1 | 1.1 | 1 | 0.1 |
| 1.2 | 1.1 | 0.1 | 1.2 | 1.1 | 0.0999999999999999 |
| 1.3 | 1.2 | 0.1 | 1.3 | 1.2 | 0.1 |
| 1.4 | 1.3 | 0.1 | 1.4 | 1.3 | 0.0999999999999999 |
| 1.5 | 1.4 | 0.1 | 1.5 | 1.4 | 0.1 |
| 1.6 | 1.5 | 0.1 | 1.6 | 1.5 | 0.1 |
| 1.7 | 1.6 | 0.1 | 1.7 | 1.6 | 0.0999999999999999 |
| 1.8 | 1.7 | 0.1 | 1.8 | 1.7 | 0.1 |
| 1.9 | 1.8 | 0.1 | 1.9 | 1.8 | 0.0999999999999999 |
| 2 | 1.9 | 0.1 | 2 | 1.9 | 0.1 |
| 2.1 | 2 | 0.1 | 2.1 | 2 | 0.1 |
| 2.2 | 2.1 | 0.1 | 2.2 | 2.1 | 0.1 |
| 2.3 | 2.2 | 0.1 | 2.3 | 2.2 | 0.0999999999999996 |
| 2.4 | 2.3 | 0.1 | 2.4 | 2.3 | 0.1 |
| 2.5 | 2.4 | 0.1 | 2.5 | 2.4 | 0.1 |
| 2.6 | 2.5 | 0.1 | 2.6 | 2.5 | 0.1 |
| 2.7 | 2.6 | 0.1 | 2.7 | 2.6 | 0.1 |
| 2.8 | 2.7 | 0.1 | 2.8 | 2.7 | 0.0999999999999996 |
| 2.9 | 2.8 | 0.1 | 2.9 | 2.8 | 0.1 |
| 3 | 2.9 | 0.1 | 3 | 2.9 | 0.1 |
| 3.1 | 3 | 0.1 | 3.1 | 3 | 0.1 |
| 3.2 | 3.1 | 0.1 | 3.2 | 3.1 | 0.1 |
| 3.3 | 3.2 | 0.1 | 3.3 | 3.2 | 0.0999999999999996 |
| 3.4 | 3.3 | 0.1 | 3.4 | 3.3 | 0.1 |
| 3.5 | 3.4 | 0.1 | 3.5 | 3.4 | 0.1 |
| 3.6 | 3.5 | 0.1 | 3.6 | 3.5 | 0.1 |
| 3.7 | 3.6 | 0.1 | 3.7 | 3.6 | 0.1 |
| 3.8 | 3.7 | 0.1 | 3.8 | 3.7 | 0.0999999999999996 |
| 3.9 | 3.8 | 0.1 | 3.9 | 3.8 | 0.1 |
| 4 | 3.9 | 0.1 | 4 | 3.9 | 0.1 |
| 4.1 | 4 | 0.0999999999999996 | 4.1 | 4 | 0.0999999999999996 |
| 4.2 | 4.1 | 0.0999999999999996 | 4.2 | 4.1 | 0.100000000000001 |
| 4.3 | 4.2 | 0.0999999999999996 | 4.3 | 4.2 | 0.0999999999999996 |
| 4.4 | 4.3 | 0.0999999999999996 | 4.4 | 4.3 | 0.100000000000001 |
| 4.5 | 4.4 | 0.0999999999999996 | 4.5 | 4.4 | 0.0999999999999996 |
| 4.6 | 4.5 | 0.0999999999999996 | 4.6 | 4.5 | 0.0999999999999996 |
| 4.7 | 4.6 | 0.0999999999999996 | 4.7 | 4.6 | 0.100000000000001 |
| 4.8 | 4.7 | 0.0999999999999996 | 4.8 | 4.7 | 0.0999999999999996 |
| 4.9 | 4.8 | 0.0999999999999996 | 4.9 | 4.8 | 0.100000000000001 |
| 5 | 4.9 | 0.0999999999999996 | 5 | 4.9 | 0.0999999999999996 |
| 5.1 | 5 | 0.0999999999999996 | 5.1 | 5 | 0.0999999999999996 |
| 5.2 | 5.1 | 0.0999999999999996 | 5.2 | 5.1 | 0.100000000000001 |
| 5.3 | 5.2 | 0.0999999999999996 | 5.3 | 5.2 | 0.0999999999999996 |
Everyone posting here is a user like you. None of us can change this. Your best opportunity to affect any change is to post a detailed bug report to Apple using the menu item "Numbers > Provide Numbers Feedback"
Is this a bug?
