Calculate Balance With Dynamic Cells

[muhammad susanto]

hi all

how to make formula to calculate balance with dynamic cells

payment	balance (desired result)
	1000 (given)
100	900
400	500
200	300

my target in blue number , thanks for your helping

susant

 

[RobP]

Hi, something like this ?

Book1
	A	B
1	payment	balance (desired result)
2		1000
3	100	900
4	400	500
5	200	300
Sheet1

Cell Formulas
Range	Formula
B3:B5	B3	=+B2-A3

 

[RobP]

thanks a lot - glad we could help.

Appreciate the feedback.

Rob