Casting running balance

[Muthukrishnan V]

MS Excel 2007.

A B C D
1 Date Withdrawal Deposit Balance
2 1000 1000
3 500 1000 1500
4 2000 2000 1500
5 1500
6 1500
7 1500

Formula in D3: =SUM(D2,C3-B3) . This formula copied down to D4 to D50.
Present entry inputs are upto B4 and C4 only. But the balance reflects 1500
in D5 to D50.
My request: In the above illustration , I want D5 to D50 to be BLANK and
show balance as and when entries are made in B and C. Thanks

 

[jtakw]

Hi,

You can do this, I don't know how you got 1500:

Book1
	B	C	D
1	Withdrawal	Deposit	Balance
2	1000	1000	0
3	500	1000	500
4	2000	2000	500
Sheet154

Cell Formulas
Range	Formula
D2	=IF(COUNT(B2:C2),SUM(D1,C2-B2),"")

D2 formula copied down, if there's no entry for both Withdrawal And Deposit, Balance column will be Blank.

 

[Muthukrishnan V]

Thank you Sir, I could not present my question in rows and columns. I do not know how to present like
how you nicely did. My input was: C2 1000. B3 500. C3 1000. B4 2000. C4 2000. Col D formula.

 

[jtakw]

You're very welcome.