rounding to multiples in excel ?

[Guest]

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.

 

[Guest]

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

 

[Guest]

have you installed the Analysis Toolpak?

TOOLS->Add-ins
then check Analysis toolpak

 

[Guest]

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

have you installed the Analysis Toolpak?

TOOLS->Add-ins
then check Analysis toolpak