Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 6th 05, 10:06 AM
Sena
 
Posts: n/a
Default 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?

  #2   Report Post  
Old August 6th 05, 02:09 PM
Bryan Hessey
 
Posts: n/a
Default


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

  #3   Report Post  
Old August 10th 05, 05:44 PM
Sena
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I find automatic links in an Excel-sheet? Tobias Excel Discussion (Misc queries) 4 August 4th 05 09:02 AM
limit text entry in a range of cells QTPRM Excel Discussion (Misc queries) 2 May 25th 05 03:52 AM
Need help with automatic date entry Mike200575 Excel Discussion (Misc queries) 2 May 19th 05 07:21 PM
double-clicking a list entry Sally Sibthorpe Excel Discussion (Misc queries) 2 February 25th 05 04:31 PM
A balance sheet Ida Lundberg Excel Worksheet Functions 3 January 28th 05 11:52 PM


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017