Round to nearest multiple

  • Thread starter Thread starter James M
  • Start date Start date
J

James M

Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some info
online about MROUND formulas but I can't seem to get it to work on my 2003
excel and it is not listed as a valid formula within the selection.

I also saw posts about ceilings and floors but I wanted a formula that would
round both up and down to the approprate multiple.

James
 
MROUND is part of the Analysis Tool Pack which must be installed before you
can use the function. If you don't want have to install the ATP then try:

=ROUND(E11/25,0)*25

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thank you! I feel guilty to say it but I just found a similar response after
I submitted my question. Thanks for your help!
 
Back
Top