+ Reply to Thread
Results 1 to 3 of 3

automatic entering Balance at every entry in my bank account

  1. #1
    Sena
    Guest

    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. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    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)


    Quote Originally Posted by 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?

  3. #3
    Sena
    Guest

    Re: automatic entering Balance at every entry in my bank account

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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1