software

How do I round to the nearest whole 5? Example 6.6 needs to be rounded
to 5 or 28 needs to be rounded to 30. The rounding function only lets
me round to tenths, hundreths, ect.
Thanks in advance.
Joe--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: www.excelforum.com/member.php...oamp;userid=21368
View this thread: www.excelforum.com/showthread...hreadid=537192=ROUND(A1/5,0)*5
or
=MROUND(A1,5)

--
Mike

quot;JoeBedquot; gt; wrote in message ...

=ROUND(A1/5,0)*5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JoeBedquot; gt; wrote in
message ...
gt;
gt; How do I round to the nearest whole 5? Example 6.6 needs to be rounded
gt; to 5 or 28 needs to be rounded to 30. The rounding function only lets
gt; me round to tenths, hundreths, ect.
gt; Thanks in advance.
gt; Joe
gt;
gt;
gt; --
gt; JoeBed
gt; ------------------------------------------------------------------------
gt; JoeBed's Profile:
www.excelforum.com/member.php...oamp;userid=21368
gt; View this thread: www.excelforum.com/showthread...hreadid=537192
gt;