Support Board
Date/Time: Tue, 16 Dec 2025 03:18:22 +0000
Post From: Rounding floats in spreadsheet
| [2021-12-10 17:15:53] |
| Sawtooth - Posts: 4299 |
|
This is not a true/false thing, this is comparing if something is above or below price at a given moment, and it's the price which is not quite fully precise.
=71=71.0000000000001 is TRUE=71<71.0000000000001 is TRUE =71>71.0000000000001 is FALSE =71.0000000000001<71.0000000000001 is FALSE =71.0000000000001>71.0000000000001 is FALSE Someone smarter than I would have to explain the above, but in reality, how often is the comparison that close? IOW, you might just have to live with it. Date Time Of Last Edit: 2021-12-10 17:18:18
|