Support Board
Date/Time: Wed, 15 Jan 2025 16:18:19 +0000
Post From: Spreadsheet Rounding to Tick Size
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4152 |
|
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) |