How do I round to the nearest 5?

[JoeBed]

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

[Mike]

=ROUND(A1/5,0)*5
or
=MROUND(A1,5)

--
Mike

"JoeBed" <[email protected]> wrote in message news:[email protected]...

[Bob Phillips]

=ROUND(A1/5,0)*5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JoeBed" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
http://www.excelforum.com/member.php...o&userid=21368
> View this thread: http://www.excelforum.com/showthread...hreadid=537192
>