Malthus101
New Member
- Joined
- Jan 23, 2017
- Messages
- 48
- Office Version
- 2016
- Platform
- Windows
Hello
I'm dealing with quite large numbers and need the "number of contracts bought or sold" rounded to the nearest 250.
So:
10112 would be rounded to 10000
10220 would be rounded to 10250
10650 would be rounded to 10750
and so on. rounded up or down, it doesn't matter. precision only necessary to whole numbers, no decimals.
In the future, I may change this to the nearest 500.
Thanks.
I'm dealing with quite large numbers and need the "number of contracts bought or sold" rounded to the nearest 250.
So:
10112 would be rounded to 10000
10220 would be rounded to 10250
10650 would be rounded to 10750
and so on. rounded up or down, it doesn't matter. precision only necessary to whole numbers, no decimals.
In the future, I may change this to the nearest 500.
Thanks.