Round to nearest multiple

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
 
S

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
 
J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top