rounding to multiples in excel ?

I am trying to round a number to a multiple of 25 in excel. I am having
trouble using the mround function. Is there a way to do this without using
MROUND? I am using Excel 2000.

Try this:

For a value in A1

This formula rounds up or down to the nearest multiple of 25. (5/4 rounding):
B1: =ROUND(A1/25,0)*25

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HR gal" wrote:

> I am trying to round a number to a multiple of 25 in excel. I am having
> trouble using the mround function. Is there a way to do this without using
> MROUND? I am using Excel 2000.

have you installed the Analysis Toolpak?

TOOLS->Add-ins
then check Analysis toolpak


"HR gal" wrote:

> I am trying to round a number to a multiple of 25 in excel. I am having
> trouble using the mround function. Is there a way to do this without using
> MROUND? I am using Excel 2000.

I installed it, but still got a #NAME? error.

"Duke Carey" wrote:

> have you installed the Analysis Toolpak?
>
> TOOLS->Add-ins
> then check Analysis toolpak
>
>
> "HR gal" wrote:
>
> > I am trying to round a number to a multiple of 25 in excel. I am having
> > trouble using the mround function. Is there a way to do this without using
> > MROUND? I am using Excel 2000.