Results 1 to 6 of 6

Daily balance sheet + making empty cells blank heeeeeeelp

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    13

    Daily balance sheet + making empty cells blank heeeeeeelp

    Hello Excel friends. Thank you for your assistance.

    It goes something like this:
    I have 3 columns. Column, A = DEBIT, B = CREDIT, C = BALANCE

    I start by inputing a starting balance in C2. The BALANCE from C2 is mirrored in C3. Then the sheet starts on line 3 with me inputing something in DEBIT(-) or CREDIT(+) or both or neither if there are no inputs for that day; if I input a DEBIT on line A3, that amount needs to be subtracted from BALANCE on C3; If I input a CREDIT on line B3, that amount needs to be added to the BALANCE on C3; If I input into both, then A3 subtracts from BALANCE and B3 adds to BALANCE.

    Along with this, I need the next line to be blank until something is inputed onto that line.

    Thus:

    ----A----------B-------------C
    1-DEBIT----CREDIT----BALANCE
    2-------------------------1000
    3-500(-)----200(+)------700 (This shows 1000 until I input something into DEBIT and/or CREDIT)
    4-300-------1000--------1400 (This line is blank until I input something into DEBIT and/or CREDIT)
    5-------------500--------1900 (This line is blank until I input something into DEBIT and/or CREDIT)
    6-1900---------------------0 (This line is blank until I input something into DEBIT and/or CREDIT)
    .
    .
    .
    40

    40 lines like this.
    Last edited by jacksoss; 07-08-2012 at 01:08 AM.

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