automatic entering Balance at every entry in my bank account

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top