T T. Valko Aug 29, 2009 #2 Do you mean round to the nearest increment of 5? One way: A1 = some number =ROUND(A1/5,0)*5
J JoeU2004 Aug 29, 2009 #3 Ashley said: How do I round a number to the nearest 5th using Excel 2003? Click to expand... Some examples would help us help you by resolving the ambiguities of an English description. If you truly mean "nearest 5th" -- multiples of 1/5 -- then any of the following equivalent formulas should do the trick. =ROUND(A1*5, 0) / 5 =MROUND(A1, 0.2) =ROUND(A1 / 0.2, 0) * 0.2 I prefer the first formula because the fractional value 0.2 cannot be represented exactly internally. (But admittedly, it's probably good enough.) If you mean nearest multiple of 5, then try any of the following: =ROUND(A1 / 5, 0) * 5 =MROUND(A1, 5) Whichever you meant, try the formulas with a number of values to be sure that you really meant "round" instead of "round up" or "round down".
Ashley said: How do I round a number to the nearest 5th using Excel 2003? Click to expand... Some examples would help us help you by resolving the ambiguities of an English description. If you truly mean "nearest 5th" -- multiples of 1/5 -- then any of the following equivalent formulas should do the trick. =ROUND(A1*5, 0) / 5 =MROUND(A1, 0.2) =ROUND(A1 / 0.2, 0) * 0.2 I prefer the first formula because the fractional value 0.2 cannot be represented exactly internally. (But admittedly, it's probably good enough.) If you mean nearest multiple of 5, then try any of the following: =ROUND(A1 / 5, 0) * 5 =MROUND(A1, 5) Whichever you meant, try the formulas with a number of values to be sure that you really meant "round" instead of "round up" or "round down".
