On Tue, 29 Mar 2005 21:36:12 +1000, "lk" wrote:

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