L
lk
I am using Excel 2003
How do you round the contents of a cell to the closest five cents.
Thanks
lk
How do you round the contents of a cell to the closest five cents.
Thanks
lk
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
=MROUND(A1,0.05)
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
B
Bob Phillips
=ROUND(C10*20,0)/20
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
L
lk
When I try to use this function I get the error "#NAME?"
lk
lk
L
lk
Thanks "CLR" it works I needed to install the analysis toolpack
lk
lk
R
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