Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JoeBed
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=384539

  #2   Report Post  
JoeBed
 
Posts: n/a
Default


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
View this thread: http://www.excelforum.com/showthread...hreadid=384539

  #3   Report Post  
swatsp0p
 
Posts: n/a
Default


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
View this thread: http://www.excelforum.com/showthread...hreadid=384539

  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

CEILING and FLOOR DO work

=FLOOR(232,10) - answer 230

--

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
View this thread: http://www.excelforum.com/showthread...hreadid=384539



  #5   Report Post  
swatsp0p
 
Posts: n/a
Default


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


Could your share your findings for others that read your thread?

Thanks,


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384539

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"