Forum Discussion
Oliver King
Jul 11, 2018Copper Contributor
Conditional Quantity formula help please
Hi folks, arranging a parts list on excel, some components have a "minimum order" of say, 5 units.
I would like to enter that I want "Required" 7, and the actual "quantity order" cell automatically multiplies the minimum order qty by a number until what I want is no longer dividable. In the example above - "Required" = 7, "minimum order" = 5 "Quantity Order" = 10
Does that make sense?
I only have a basic knowledge of IF and one or two other statements and struggling to see how to do this without some sort of macro or looped statement?
Thanks,
1 Reply
- Oliver KingCopper Contributor
I think I did it!
Req. per Enc Mod Total Required Min Order Multiple Left over 1 1 1 1 1 8 8 1 8 1 6 6 5 1.2 10
Final column has formula =IF(J7<=1,(I7),(ROUNDUP(J7,0)*(I7)))