HELP! Rounding in Excel!?
 

How do I round a number to the nearest 5th using Excel 2003?
HELP!

HELP! Rounding in Excel!?
 

Do you mean round to the nearest increment of 5?

One way:

A1 = some number

=ROUND(A1/5,0)*5

--
Biff
Microsoft Excel MVP


"Ashley" wrote in message
...
How do I round a number to the nearest 5th using Excel 2003?
HELP!

HELP! Rounding in Excel!?
 

"Ashley" wrote:
How do I round a number to the nearest 5th using Excel 2003?

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".