Login Page - Create Account

Support Board


Date/Time: Tue, 30 May 2023 05:36:50 +0000



Rounding a calculation to tick level

View Count: 1995

[2013-06-24 16:41:00]
RPinCAR - Posts: 27
Is there a function that will allow me to round a calculation in a spreadsheet to the nearest tick value. For example, instead of 1557.40, I would get 1557.50 in the ES.
Thanks,
[2013-06-24 17:22:12]
tomgilb - Posts: 3629
Use MROUND function.

http://office.microsoft.com/en-us/excel-help/mround-HP005209185.aspx?CTT=5&origin=HP005204211
[2013-06-24 17:25:46]
RPinCAR - Posts: 27
Thank you sir, perfect as: =MROUND((Sheet1!BE3+Sheet1!BF3)/2,0.25)

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account