[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[_2_]]

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

[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


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

[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!

"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

[David Biddulph[_2_]]

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