Forum Discussion

Oliver King's avatar
Oliver King
Copper Contributor
Jul 11, 2018

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 King's avatar
    Oliver King
    Copper Contributor

    I think I did it!

    Req. per Enc ModTotal RequiredMin OrderMultipleLeft over
    11111
    88181
    6651.210


    Final column has formula =IF(J7<=1,(I7),(ROUNDUP(J7,0)*(I7)))

Resources