Support Board
Date/Time: Tue, 01 Jul 2025 00:03:49 +0000
Post From: Spreadsheet Rounding to Tick Size
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4231 |
|
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) |