Support Board
Date/Time: Sat, 23 Nov 2024 06:51:36 +0000
Rounding a calculation to tick level
View Count: 2348
| [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] |
| Sawtooth - Posts: 4118 |
|
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: