|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com