Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rounding to closest 5 cents
I am using Excel 2003
How do you round the contents of a cell to the closest five cents. Thanks lk |
#2
|
|||
|
|||
=MROUND(A1,0.05)
Vaya con Dios, Chuck, CABGx3 "lk" wrote in message ... I am using Excel 2003 How do you round the contents of a cell to the closest five cents. Thanks lk |
#3
|
|||
|
|||
=ROUND(C10*20,0)/20
-- HTH RP (remove nothere from the email address if mailing direct) "lk" wrote in message ... I am using Excel 2003 How do you round the contents of a cell to the closest five cents. Thanks lk |
#4
|
|||
|
|||
When I try to use this function I get the error "#NAME?"
lk "CLR" wrote in message ... =MROUND(A1,0.05) Vaya con Dios, Chuck, CABGx3 "lk" wrote in message ... I am using Excel 2003 How do you round the contents of a cell to the closest five cents. Thanks lk |
#5
|
|||
|
|||
Thanks "CLR" it works I needed to install the analysis toolpack
lk "lk" wrote in message ... When I try to use this function I get the error "#NAME?" lk "CLR" wrote in message ... =MROUND(A1,0.05) Vaya con Dios, Chuck, CABGx3 "lk" wrote in message ... I am using Excel 2003 How do you round the contents of a cell to the closest five cents. Thanks lk |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Closest number match help ... | Excel Worksheet Functions |