Support Board
Date/Time: Wed, 27 Nov 2024 19:41:32 +0000
Post From: round method in spreadsheet
| [2014-09-18 23:35:10] |
| Sawtooth - Posts: 4120 |
|
the ROUND function rounds to the nearest, either up or down. To round to tick size, use the MROUND function: =MROUND(n,$J$21) If J21 has floating point errors, you can eliminate them with this in H21: =1/ROUND(1/J21,0) then use: =MROUND(n,$H$21) The MROUND function rounds to the nearest multiple, either up or down. Date Time Of Last Edit: 2014-09-19 01:21:58
|