Support Board
Date/Time: Tue, 04 Mar 2025 15:15:57 +0000
Post From: Rounding floats in spreadsheet
| [2021-12-10 14:36:05] |
| Sawtooth - Posts: 4179 |
|
Unfortunately it doesn't work consistently. It works for prices in cells J48 and J49, but not for J94 and J96. Those get rounded to zero decimals so in CL for example, I get prices of 70.
I can't reproduce this. It works as expected for me. I never see any floating point errors with this solution.Aha, but doing an MROUND of J21 and using that LEN trick as what it gets rounded with, seems to work!
MROUND is not part of the LEN solution. What multiple are you using to MROUND J21 ?I spoke too soon. Cell J49 is currently returning a float even after being rounded with this LEN string solution. Actually, it's not possible to remove all floating point imprecision. You can only reduce it to something very small. A .0000000000001 float is not a large enough error to return FALSE in this equation: =1=1.0000000000001 |