Thanks:  0
Likes:  0

# Thread: How do I round up or down to nearest 5?

1. This must be simple, but with ROUNDUP and ROUNDDOWN, I can round up or down to nearest 10 or multiple of 10 by using -1, -2, -3 etc. as the second argument.

But how do I round up or down to the nearest 5? For example, 862 to 860 and 863 to 865?

To the nearest 50? 1210 to 1200 and 1230 to 1250?

2. see help for MROUND.
Should do the trick!
mb
NOTE: If I recall, you may have to install this formula from disk, isn't part of standard install...

3. On 2002-03-13 11:52, Barry Katcher wrote:
This must be simple, but with ROUNDUP and ROUNDDOWN, I can round up or down to nearest 10 or multiple of 10 by using -1, -2, -3 etc. as the second argument.

But how do I round up or down to the nearest 5? For example, 862 to 860 and 863 to 865?

To the nearest 50? 1210 to 1200 and 1230 to 1250?

=ROUND(A1/5,0)*5

MROUND can do the same.

4. On 2002-03-13 11:52, Barry Katcher wrote:
This must be simple, but with ROUNDUP and ROUNDDOWN, I can round up or down to nearest 10 or multiple of 10 by using -1, -2, -3 etc. as the second argument.

But how do I round up or down to the nearest 5? For example, 862 to 860 and 863 to 865?

To the nearest 50? 1210 to 1200 and 1230 to 1250?

A Tip: There's a "See Also" link in the upper left hand corner of the Excel Help topics for "ROUNDUP worksheet function" and "ROUNDDOWN worksheet function". This would have steered you to MROUND.

[ This Message was edited by: Mark W. on 2002-03-13 11:59 ]

5. ## Re: How do I round up or down to nearest 5?

=ROUND(A1/5,0)*5

MROUND can do the same.
The first option is best... the disadvantage of MROUND is that it doesn't work when you round a negative number.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•