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.
Bookmarks