F2= 100. This is the Ideal stock level
In cell F4 create a formula that will calculate the buy in value. THis is the ideal stock level minus the current quantity to establish the amount to be bought/ordered. Use an absolute reference for the ideal stock level
Solved by O. J. in 28 mins