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!
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!
Try this (f your value is in cell A1):
=ROUND(A1/0.0005,0)*0.0005
- Moo
Thank you Moo, worked like a charm!
Hi
try![]()
= ROUND(63.8828,3)
Maybe..
![]()
=MROUND(A1,0.0005)
Life's a spreadsheet, Excel!
Say thanks, Click *
Of course, if you always want to round UP, then you can use this:
=CEILING(A1,0.0005)
- Moo
Glad to help.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks