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?
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)
Originally Posted by 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks