rounding to closest 5 cents

[lk]

I am using Excel 2003

How do you round the contents of a cell to the closest five cents.

Thanks
lk

 

[CLR]

=MROUND(A1,0.05)

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

=ROUND(C10*20,0)/20

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[lk]

When I try to use this function I get the error "#NAME?"
lk

 

[lk]

Thanks "CLR" it works I needed to install the analysis toolpack
lk

 

[Ron Rosenfeld]

I am using Excel 2003

How do you round the contents of a cell to the closest five cents.

Thanks
lk

If you have the Analysis ToolPack installed:

=mround(A1,0.05)

If you do NOT have the ATP installed:

=ROUND(A1/0.05,0)*0.05


--ron