ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   automatic entering Balance at every entry in my bank account (https://www.excelbanter.com/excel-discussion-misc-queries/39084-automatic-entering-balance-every-entry-my-bank-account.html)

Sena

automatic entering Balance at every entry in my bank account
 
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)


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


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




All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com