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