Return multiple of a number based on a maximum and minimum quantity

I need to create a formula to tell me to order multiples of box qty, to cover required qty, up to but not exceeding fixed order qty. Please see attached. Thank you

Put this formula in E2:

=MIN(D2,INT(C2/B2)+1)

then copy down.

Hope this helps.

Pete

Pete,

Thank you for your help. Unfortunately, this isn't quite what I was looking for. Please see updated attachment for perhaps a clearer explanation of my goal.

Thanks again,
Dan