Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
This must be simple, but with ROUNDUP and ROUNDDOWN, I can round up or down to nearest 10 or multiple of 10 by using -1, -2, -3 etc. as the second argument.
But how do I round up or down to the nearest 5? For example, 862 to 860 and 863 to 865?
To the nearest 50? 1210 to 1200 and 1230 to 1250?
Thanx in advanx.
But how do I round up or down to the nearest 5? For example, 862 to 860 and 863 to 865?
To the nearest 50? 1210 to 1200 and 1230 to 1250?
Thanx in advanx.