Remember Me?

#1
 JoeBed Posts: n/a
Round whole numbers up and down

I have a cell that has a whole number.I want round it to the nearest
muliple of 5.
Examples:
231 round down to 230
232 round down to 230
233 round up to 235
234 round up to 235
235 = 235
236 round down to 235
237 round down to 235
238 round up to 240
239 round up to 240
240 =240
and so on
Is there a formula to do this. Ceiling and Floor does not work.
Thanks for any help
Joe

--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: http://www.excelforum.com/member.php...o&userid=21368

#2
 JoeBed Posts: n/a

Please disregard the post. I found my answer in a previous post. When I
did a search, I couldn't find it. I found my answer by luck on page 2.
T
Thanks Joe

--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: http://www.excelforum.com/member.php...o&userid=21368

#3
 swatsp0p Posts: n/a

Try using MROUND, as such:

=MROUND(A1,5)

does this work for you?

Bruce

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101

#4
 Bob Phillips Posts: n/a

CEILING and FLOOR DO work

--

HTH

RP
(remove nothere from the email address if mailing direct)

"JoeBed" wrote in
message ...

I have a cell that has a whole number.I want round it to the nearest
muliple of 5.
Examples:
231 round down to 230
232 round down to 230
233 round up to 235
234 round up to 235
235 = 235
236 round down to 235
237 round down to 235
238 round up to 240
239 round up to 240
240 =240
and so on
Is there a formula to do this. Ceiling and Floor does not work.
Thanks for any help
Joe

--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile:

http://www.excelforum.com/member.php...o&userid=21368

#5
 swatsp0p Posts: n/a

JoeBed Wrote:
Please disregard the post. I found my answer in a previous post. When I
did a search, I couldn't find it. I found my answer by luck on page 2.
T
Thanks Joe

Thanks,

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 09:50 AM.