Does anyone know if there is a way of using a formulas to round up to a specified number. To explain what I mean, in the manually written example we have products that come in cases but we sell as both cases and single units. What I want to do is set a maximum fill level for the singles when we transfer the stock from cases to singles.
So to put it in terms of the table I need to round up the peak sales (column G) to the nearest multiple of the pack (column F) and then add on 1 multiple of the pack as a buffer stock for fluctuation in sales.
For example in row 4: the peak sales is 16, the nearest multiple of the pack is 18 and adding 1 pack as buffer will give a Max fill of 24
Last edited by WasWodge; 08-05-2010 at 04:23 PM.
I *think* you're asking for:
H4: =CEILING(G4,F4)+F4
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Yes that seems to be the one. I will now try to apply it at work tomorrow where there are various vlookup's but I don't anticipate any problems. The annoying thing is I did look at "ceiling" at work but didn't grasp it the way that it was being described, but you live and learn.Many thanks for your help as it wil save a lot of time as the proper spreadsheet contains over 300 products
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks