+ Reply to Thread
Results 1 to 4 of 4

How to keep record of balance on each amount withdrawn from a bank account opperation

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Ivory Coast
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to keep record of balance on each amount withdrawn from a bank account opperation

    Please I am having problem with some formula functions in excel 2010, below is the problems that I am having.
    I have 4400000 XOF paid in my bank account and have withdrawn in-several occasions some money from that account, how can I run the automatic calculation in excel 2010 so that each time that I withdraw money it will be subtracted on its own and show the remaining amount in the bank instead of giving me the global amount that left in the account after all withdrawn.
    I mean each of every withdrawn will have its own record of amount left.
    Please see the attached excel file for the original account sheet
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to keep record of balance on each amount withdrawn from a bank account opperation

    In E3

    Please Login or Register  to view this content.
    copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    Ivory Coast
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: How to keep record of balance on each amount withdrawn from a bank account opperation

    Thank you Ace but please how can I past the code for the result of the balance (subtraction) resulted from B18 and each of column C cell (C6 to C17) to be shown in D6 to D17 .
    please I attached again a file to show the sample.
    Thanks
    Attached Files Attached Files
    Last edited by samson jerry; 01-04-2013 at 08:29 AM.

  4. #4
    Registered User
    Join Date
    01-04-2013
    Location
    Ivory Coast
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: How to keep record of balance on each amount withdrawn from a bank account opperation

    Sorry I was messing up, your formatting code is exactly what I needed and it worked exactly the way that I wanted when I typed the code right where it supposed to be, thanks for you help.

+ 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