Keep running if statement until desired value reached

Hey Guys and Girls!
We are trying to run a formula to help us with reordering our stock.

we have set the order rate at 7.53, which is the average amount of time we would usually take to order from this supplier. We have also we the average days it takes to order this specific product.

so we ran an if statement which works fine when the stock rate is more then the reorder rate, as it returns value of 1. We then order 1 item.
But I need the if statement to keep adding up until it reaches the order rate, so we know how many to order when then frequency of order is less than the average reorder.

Average Reorder Frequency 7.53
Frequency of order for this product 4

so we should order a box every 4 days, but our average reorder frequency is 7.53 days, so in affect we would order 2 boxes almost every week until we reach max, then we would order 1, because or stock of that product wont run out before next order

Thanks for this, are you able to expalin how this works for me ?

Originally Posted by Kaper

first week (G6) you order 2 boxes. 2*4 = 8 which covers your requirement of 7.53
second week again 2 boxes, because you need 2*7.53 - 8 ordered first week
third week 3*7.53 -16 etc.
so as you copy formula down row (a1)=1 changes into row(A2)=2, etc
part: 7.53*row(a1) represents accumulated needs till current week
the sum of all above multiplied by 4 is total number ordered so far
the difference between two above is current need, and it is rounded up to nearest 4 (as you cannot order 3/4 of box) and it is the number of needed gloves
then it is divided by 4 to get number of boxes needed.

Thanks for this, it's all make sense and looks good. Only missing requirement is if we order out of sequence. Ie I have how many days since last order. This is so I could take into account public holidays