Help to adjust a formula

[Alejandro Rodriguez]

.
Hello,

I have the below table.
I need to adjust the formula of column F (BALANCE) in order to give me the results required.

I tried with:

F6 = IF(E6>0,SUM(F5)+IF(B6>0,(A6*B6),0)-IF(C6>0,(F5/D5)*C6,0),0)

but doesnt work.

Any suggestion how to adjust the formula?
No problem if there is another way to do it. Better not using Conditional Formatting and an Auxiliar Column.

Thank you in advance for your help.

Excel 2003
	A	B	C	D	E	F	G	H	I	J
1
2
3
4		2,250	1,610	640	640	1,100.00		11,597.24		152,147.12
5	PRICE	IN	OUT	Q'TY	ON HAND	BALANCE		RESULT REQUIRED		BAL
6	15.00	100		100	0	0.00		0.00		1,500.00
7			50	50	0	0.00		0.00		750.00
8	20.00	200		250	0	0.00		0.00		4,750.00
9			200	50	0	0.00		0.00		950.00
10			30	20	0	0.00		0.00		380.00
11	10.00	1,000		1,020	0	0.00		0.00		10,380.00
12	18.00	200		1,220	0	0.00		0.00		13,980.00
13			70	1,150	0	0.00		0.00		13,177.87
14			150	1,000	0	0.00		0.00		11,459.02
15	30.00	400		1,400	0	0.00		0.00		23,459.02
16			200	1,200	0	0.00		0.00		20,107.73
17			500	700	0	0.00		0.00		11,729.51
18			350	350	0	0.00		0.00		5,864.75
19	19.00	300		650	0	0.00		0.00		11,564.75
20			60	590	0	0.00		0.00		10,497.24
21	22.00	50		640	640	1,100.00		11,597.24		11,597.24
22
INV

Cell Formulas
Range	Formula
B4	=SUM(B6:B65536)
C4	=SUM(C6:C65536)
D4	=B4-C4
D6	=SUM(B$6:B6)-SUM(C$6:C6)
E4	=SUM(E6:E65536)
E6	=IF(COUNT(B7:C7)>0,0,SUM(B$6:B6)-SUM(C$6:C6))
F4	=SUM(F6:F65536)
F6	=IF(E6>0,SUM(F5)+IF(B6>0,(A6*B6),0)-IF(C6>0,(F5/D5)*C6,0),0)
H4	=SUM(H6:H65536)
J4	=SUM(J6:J65536)
J6	=SUM(J5)+IF(B6>0,(A6*B6),0)-IF(C6>0,(J5/D5)*C6,0)

 

[StefanVL]

What's the required result in F6 and F7?

 

[Alejandro Rodriguez]

.
is 0

Column F depends of column E
If column E is 0 then column F is 0
If column E > 0 then column F is SUM(F5)+IF(B6>0,(A6*B6),0)-IF(C6>0,(F5/D5)*C6,0)

thank you for your help.

PS. My results required are shown in column H
.