Support Board
Date/Time: Fri, 12 Sep 2025 11:48:08 +0000
Post From: Spreadsheet Rounding to Tick Size
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4263 |
|
This is how I do it: 1) Round the ticksize to remove any floating point errors, e.g. in H21: =1/ROUND(1/J21,0) 2) Reference H21 using the MROUND function: =MROUND(calculatedvalue,$H$21) |