Round the 4th decimal to the nearest 5 or 0

**Zaxivette** · 02-14-2013, 01:39 PM

How can I round up the 4th decimal to the nearest 5 or 0. For example, if I have 63.8828, the rounding result I would expect is 63.8830.

Thank you!

**Moo the Dog** · 02-14-2013, 01:44 PM

Try this (f your value is in cell A1):

=ROUND(A1/0.0005,0)*0.0005

- Moo

**Pepe Le Mokko** · 02-14-2013, 01:44 PM

Hi
try

Please Login or Register  to view this content.

**Ace_XL** · 02-14-2013, 01:47 PM

Maybe..

Please Login or Register  to view this content.

**Moo the Dog** · 02-14-2013, 01:48 PM

Of course, if you always want to round UP, then you can use this:

=CEILING(A1,0.0005)

- Moo

**Zaxivette** · 02-14-2013, 01:51 PM

Thank you Moo, worked like a charm!

**Moo the Dog** · 02-14-2013, 01:57 PM

Glad to help.

Re: Round the 4th decimal to the nearest 5 or 0