Round to nearest multiple
 

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

Round to nearest multiple
 

Hi James

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

HTH. Best wishes Harald

"James M" wrote in message
...
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

Round to nearest multiple
 

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


Replace @mailinator.com with @tiscali.co.uk


"James M" wrote in message
...
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

Round to nearest multiple
 

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

"Harald Staff" wrote:

Hi James

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

HTH. Best wishes Harald

"James M" wrote in message
...
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

Round to nearest multiple
 

Did you look up MROUND in Excel help?
--
David Biddulph

"James M" wrote in message
...
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