rounding to multiples in excel ?

H

HR gal

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.
 
R

Ron Coderre

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
 
D

Duke Carey

have you installed the Analysis Toolpak?

TOOLS->Add-ins
then check Analysis toolpak
 
Top