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
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
=ROUND(A1/5,0)*5
or
=MROUND(A1,5)
--
Mike
"JoeBed" <[email protected]> wrote in message news:[email protected]...
=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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks