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