Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 17:41:14 +0000

How to Post a Message for Support

Post From: round method in spreadsheet

[2014-09-18 23:35:10]
[Go To First Post]
Sawtooth - Posts: 3993
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