Which formula in Excel should I use?

I need to make a formula in Excel that can do the following:

CODE	DESCRIPTION	ORDER QTY	Model Stock	Stock on Hand	Sold QTY
CODE1	CODE 1 ITEM	24, 48, 72, 96, 120, 144, 168	120	78	15
CODE2	CODE 2 ITEM	6, 10, 15, 20, 25, 30, 35, 40	20	8	8
CODE3	CODE 3 ITEM	10, 20, 30, 40, 50, 60, 70	10	1	1

I have the following columns :

CODE
DESCRIPTION
ORDER QTY
Model Stock
Stock on Hand
Stock QTY
Order QTY

On the same sheet, different items have different order quantities, so I cannot put a universal formula that would just round up to a specific group of numbers.

I need the QTY column to calculate and enter Order QTY, by using the Sold QTY column amount, but entered in the specific number range in the Order QTY column.

So for example CODE1, Sold QTY is 15, Order QTY is 24, 48, 72 etc. It would need to enter 24 in the Order QTY column.

CODE2 item, Sold QTY is 8, Order QTY is 6, 10, 15 etc. It would need to enter 10 in the Order QTY column and Round Up to the higher number in the Order QTY column, so not to use to 6, but rather the 10.