Round to nearest multiple

[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

 

[Harald Staff]

Hi James

The hard way:
=ROUND(A1/25,0)*25

HTH. Best wishes Harald

 

[Sandy Mann]

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

 

[James M]

Thank you! I feel guilty to say it but I just found a similar response after
I submitted my question. Thanks for your help!

 

[David Biddulph]

Did you look up MROUND in Excel help?