08-11-2021, 07:08 AM
|
|
Expert
|
|
Join Date: May 2013
Location: USA
Posts: 700
|
|
I haven't tested this code (I'm about to clock in to my real job so I won't take the time now), but if you're asking to round any number up to its next multiple of 50, I'd probably start by trying the MROUND function. Let's see, here... (I said I wouldn't take the time, but apparently my interest has been caught ) ...=MROUND(<number>+24,50) seems to do it. MROUND rounds it to the nearest multiple, not the highest, so you add 24 (just less than half of 50) to your number, then round to the nearest multiple of 50, and that seems to work for me.
|