Menu
Anyone know a function that rounds up a number to the nearest ten or hundred or thousand etc.
Basically I would like to create a function that would round these numbers to these:
25-30
51-60 etc.
then if the number is in the hundreds then
101-200
240-300 etc.
then if the number is in the thousands then
1001 to 2000 etc.
This may not even be possible but would quite like to know. If someone could tell me how to round up to nearest thousand then I should be able to work out the rest.
Thanks in Advance,
Ben