Support Board
Date/Time: Wed, 29 Oct 2025 00:12:05 +0000
Post From: Spreadsheet Rounding to Tick Size
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4281 |
|
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) |