rounding in excel 2000

[Jennifer]

Hello! I have a question about rounding in Excel 2000. I
am trying to round numbers to the nearest quarter,
i.e. .25, .5, .75, and a whole number. Is it possible to
do this? I appreciate any help.

Jennifer

 

[Niek Otten]

=MROUND(A1,.25)

If the MROUND function is not available: Tools>Add-Ins, check Analysis
Toolpak

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Bob Umlas]

=ROUND(A1/0.25,0)*0.25