Support Board
Date/Time: Tue, 04 Mar 2025 15:03:34 +0000
Post From: Rounding floats in spreadsheet
| [2021-12-09 21:58:21] |
| John - SC Support - Posts: 38341 |
|
You have to use the following formula as defined in the link you reference above: =MROUND(CalculatedValue,$H$21) Where "CalculatedValue" is the cell that contains the value you want to round. And H21 contains the formula to round the Tick Size. For example, if you have your formula in H96 (as mentioned above), then you would have the following: Cell H21: = 1 / (ROUND(1 / J21, 0) Cell H96: Your formula Cell H97 (or whatever cell you want it in): =MROUND($H$96, $H$21) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |