I have calculated the par levels for weekly ordering and thats fine.

I am trying to figure out a formula which can calculate me the amount to be ordered on the basis of the closing stock on a Sunday night.

For example :

Par level for Anchovies is 35 pkts ( in cell c3)

Closing stock for Anchovies is 24 ( this is on another sheet called "average use")

It would be easy to calculate 35-24 , however the case size for Anchovies is 24 pcs in one box. I cannot order less.

So if the quantity goes below 35 pkts, what formula would give me the figure "1" ( which would mean 1 box) in cell D3 , where I want the "To order" quantity to be.

Makes sense.??

I have a whole list of about 100 items with different case sizes. It would be fantastic , if I could just feed the closing stock and it calculates me what to order, in the particular case size

ANy help would be highly appreciated

Many thanks