Support Board
Date/Time: Wed, 01 Jan 2025 14:19:50 +0000
Post From: Spreadsheet-Rare bug in Greater than or Equal?
| [2016-05-13 20:33:02] |
| User791263 - Posts: 151 |
|
I had forgotten about that, since the problem is seldom seen. I'm surprised it is not seen more often, but it must be happening more than I've noticed. That means a lot of review, caution and refinements. We should all study that link more: https://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php#ImprecisionOfFloatingPointNumbers I've tried to carefully match decimal places all along, but that is not sufficient. Both solutions you all offer work well. Apparently a near-but-lower or higher decimal and range for the comparison test solves the issue. Thanks much. |