| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Linear Mode
