Excel

[alliswell]

calculation.xlsx
	A	B	C	D	E	F	G	H	I
1	Sr. No	Date	Products	Quantity	Rate	Amount	Paid	Balance	-908
2	1	5/10/2021	Pens	5	5	25	33	-900
3	2	6/10/2021	pencils	7	8	56	23	-933
4
5							17
6
7							16
8	when I drag H2 downwards till H13, it leaves spaces in between and displays
9	the H3 results from H11:H13
10	and when I type in column G it must give results in H5 (-916) rather it gets
11	changed in H11:h13 and when I type figure in G7 the							-900
12	results should get in H7(-900) but it changes in H11:H13							-900
13	pls check if my formula is correct.							-900
Sheet1

Cell Formulas
Range	Formula
F2:F10	F2	=IF((D2+E2)>0,D2*E2,"")
H2:H13	H2	=IF(COUNT(F2+G2)>0,-SUM($F$2:$F2)+SUM($G$2:$G2)+$I$1,"")

 

[mohadin]

=IF(COUNT(F2+G2)>0,-SUM($F$2:F2)+SUM($G$2:G2)+$I$1,"")

 

[bebo021999]

F2:
=IFERROR(1/(1/D2*E2),"")
H2:
=IFERROR($I$2+SUM($G$2:$G2)-SUM($F$2:$F2),"")

 

[Peter_SSs]

Perhaps this?

21 11 05.xlsm
	D	E	F	G	H	I
1	Quantity	Rate	Amount	Paid	Balance	-908
2	5	5	25	33	-900
3	7	8	56	23	-933
4
5				17	-916
6
7				16	-900
8
9
10
11
12
13
Balance

Cell Formulas
Range	Formula
F2:F13	F2	=IF(COUNT(D2:E2)=2,D2*E2,"")
H2:H13	H2	=IF(F2&G2="","",IFERROR(LOOKUP(9.99E+307,H$1:H1),I$1)-N(F2)+G2)

 

[alliswell]

yes peter it works the way i liked to...... love you love you a lot muah........
i was really awaiting you

 

[Peter_SSs]

You're welcome. Glad it was what you wanted.