automatic entering Balance at every entry in my bank account

[Sena]

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]

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)

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?

[Sena]

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
>
>