Every time I enter RECEIPTE in my bank Account, I wish the BALANCE column
automatically gets added . Similarly when I enter payment, BALANCE to be
reduced
Possible?

Just make the Balance column dependant on a figure being present in
Receipts or Payments,

=if(or(B5<0,C5<0),D4+B5-C5,"")

should work. (formula-drag that down the column)


Sena Wrote:
Every time I enter RECEIPTE in my bank Account, I wish the BALANCE
column
automatically gets added . Similarly when I enter payment, BALANCE to
be
reduced
Possible?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=393537

Bryan, U R great ! Your formula works. Works fine. Thank U.

"Bryan Hessey" wrote:


Just make the Balance column dependant on a figure being present in
Receipts or Payments,

=if(or(B5<0,C5<0),D4+B5-C5,"")

should work. (formula-drag that down the column)


Sena Wrote:
Every time I enter RECEIPTE in my bank Account, I wish the BALANCE
column
automatically gets added . Similarly when I enter payment, BALANCE to
be
reduced
Possible?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=393537