Hi,
I need to be able to round a given number (stock required) up to the next multiple of another number (pack size), as in the attached example.
Also, is there a way I can round to the closest multiple, ie either up or down, depending on which multiple is closer? I haven't decided which way I want to go yet!
Thanks,
This works on most of your values, but there are some that your original "conversion" does not make sense....
=MROUND(IF(C8<C$4/2,C$4,C8),C$4)
(you have 28 with a case of 8, that you round to 16? why not 24?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks Ford, works perfectly! Don't worry about the 28 case 8 round to 16 - it was a typo...
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks