Special Rounding

When you need to round to a certain number, e.g. 5 cents, you can use the MROUND function.

If cell A1 contains a number then the following formula will round the value to the closest 5 cent value.

=MROUND(A1,0.05)

The MROUND function does have some issues – see this blog post.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.