Support Board
Date/Time: Thu, 24 Sep 2026 12:30:09 +0000
Post From: Spreadsheet Rounding to Tick Size
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4354 |
|
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) |