How do I round up or down to nearest 5?

[Barry Katcher]

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?

Thanx in advanx.

[marbel]

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

[Aladin Akyurek]

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?

Thanx in advanx.

=ROUND(A1/5,0)*5

MROUND can do the same.

[Mark W.]

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?

Thanx in advanx.

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 ]