Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I round to the nearest 5?

1 view
Skip to first unread message

JoeBed

unread,
Apr 28, 2006, 9:21:37 AM4/28/06
to

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?action=getinfo&userid=21368
View this thread: http://www.excelforum.com/showthread.php?threadid=537192

Mike

unread,
Apr 28, 2006, 9:31:04 AM4/28/06
to
=ROUND(A1/5,0)*5
or
=MROUND(A1,5)

--
Mike

"JoeBed" <JoeBed.26z7nm_...@excelforum-nospam.com> wrote in message news:JoeBed.26z7nm_...@excelforum-nospam.com...

Bob Phillips

unread,
Apr 28, 2006, 9:34:07 AM4/28/06
to
=ROUND(A1/5,0)*5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JoeBed" <JoeBed.26z7nm_...@excelforum-nospam.com> wrote in
message news:JoeBed.26z7nm_...@excelforum-nospam.com...
>

0 new messages