Daily balance sheet + making empty cells blank heeeeeeelp

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

2. Re: Daily balance sheet + making empty cells blank heeeeeeelp

In C3, then copied down:

=IF(COUNT(A3:B3)=0, "", C2-A3+B3)

3. Re: Daily balance sheet + making empty cells blank heeeeeeelp

Alternatively,

=IF(AND(A3="",B3=""),"",C2-A3+B3)

4. Re: Daily balance sheet + making empty cells blank heeeeeeelp

Thank you, thank you, thank you. Being a noob, my research would've never led me to those formulas.

5. Re: Daily balance sheet + making empty cells blank heeeeeeelp

I am looking for something very simalar except with 4 columns instead of 3. I need it to pull prefferably a blank or second prefference a zero in column D if columns A,B or C or empty. I did try this fix but no luck for me. This thread seemed close to what I was looking for and was answered just yesterday, If commented I can easily just start a new thread. Thanks a ton!!

D=Formaula
A-----------B----------C------------------D----------------------------
30 ----- 0.3571 ----0.3838---------- [=SUM((C1-B1)*(1000000)/A1)]
A-----------B----------C------------------D----------------------------
Blank --- Blank --- Blank------------ [=IF(COUNT(A2:C2)=0,"",C2-B2)*(1000000)/A2]
A-----------B----------C------------------D----------------------------

Never mind, after fooling around this fixed it [=IF(COUNT(A2:C2)=0, "", (C2-B2)*1000000/A2)]

ExcelForum has been Great!!! Thanks!!

6. Re: Daily balance sheet + making empty cells blank heeeeeeelp

Originally Posted by Ace_XL
Alternatively,

=IF(AND(A3="",B3=""),"",C2-A3+B3)
Cool, this is awesome, cuz I just changed it to =IF(OR
and that helped me because (A) is Quantity and (B)
is unit price and (C) is the total... so if A OR B are
blank then the Total cell shows blank instead of
the n/a or value errors.

Many Blessings,
Jerold

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

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