rounding in excel 2000

J

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
 
N

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
 
Top