 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007MROUND to only round up
I am using MROUND to the nearest 5. And I need it to only round up. Is this possible? (this is a formula for sizing a container, so if the item's width is 22" for example, my container needs to be 25"). Any suggestions would be great - thanks. laurie You can't do it with MROUND, but applying a bit of maths and using ROUNDUP will get you what you want. Divide your value by 5, round up to the next whole number by specifying 0 decimal places, then multiply by 5 =ROUNDUP(A1/5,0)*5  SignatureIan -- >I am using MROUND to the nearest 5. And I need it to only round up. > Is this possible? > (this is a formula for sizing a container, so if the item's width is > 22" for example, my container needs to be 25"). > Any suggestions would be great - thanks. laurie Or without any division and multiplying =CEILING(A1,5) SignatureRegards, Peo Sjoblom > You can't do it with MROUND, but applying a bit of maths and using ROUNDUP > will get you what you want. [quoted text clipped - 9 lines] >> 22" for example, my container needs to be 25"). >> Any suggestions would be great - thanks. laurie There always seems to be a keyword for what you need. I'd never come across CEILING before. Nice solution! SignatureIan -- > Or without any division and multiplying > [quoted text clipped - 13 lines] >>> 22" for example, my container needs to be 25"). >>> Any suggestions would be great - thanks. laurie FLOOR does the opposite and rounds down SignatureRegards, Peo Sjoblom > There always seems to be a keyword for what you need. I'd never come > across CEILING before. Nice solution! [quoted text clipped - 16 lines] >>>> 22" for example, my container needs to be 25"). >>>> Any suggestions would be great - thanks. laurie Thanks for the pointer. Hopefully CEILING is what terrapinie wants. SignatureIan -- > FLOOR does the opposite and rounds down > [quoted text clipped - 18 lines] >>>>> 22" for example, my container needs to be 25"). >>>>> Any suggestions would be great - thanks. laurie Thanks guys!! I will try the CEILING function tomorrow when I get back to work.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.