USE OF CIRCULAR FORMULA

[Terminator]

Hello,
I have a problem to solve regarding placing the orders for materials before the material runs out from the stock.
for example in the image below, row 2 shows the demand per week of part x. Row 3 shows the stock inventory after consuming the week's demand plus the shipment received in that week.
I need to place orders each week to keep inventory low but the inventory should not fall below safety stock of 22 pieces.
When I write IF function to calculate the shipment orders, Row 3 shows a circular formula error. So I activate the iterations but then the value in Shipment becomes zero.

Is there any other formula that can be used in Row 4 so that it can give value but does not disappear from there? or how can I get the value of the if function to stay there after all the calculations?

 

[Skybluekid]

Try

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2			24-Apr	01-May	08-May	15-May	22-May	29-May	05-Jun
3		Demand	22	18	23	10	9	15	16
4		Run Inv	23	17	10	15	30	25	19
5		Shipment		12	16	15	24	10	10
6
7
Sheet3

Cell Formulas
Range	Formula
D4:I4	D4	=IF(D3="","",(C4-D3)+D5)

 

[Terminator]

Try

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2			24-Apr	01-May	08-May	15-May	22-May	29-May	05-Jun
3		Demand	22	18	23	10	9	15	16
4		Run Inv	23	17	10	15	30	25	19
5		Shipment		12	16	15	24	10	10
6
7
Sheet3

Cell Formulas
Range	Formula
D4:I4	D4	=IF(D3="","",(C4-D3)+D5)

Hello,
The values in SHIPMENT field disappears once i write down the formula in RUN INV FIELDS.

I have formula in SHIPMENT field as follows: