+ Reply to Thread
Results 1 to 6 of 6

Daily balance sheet + making empty cells blank heeeeeeelp

  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.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Daily balance sheet + making empty cells blank heeeeeeelp

    In C3, then copied down:

    =IF(COUNT(A3:B3)=0, "", C2-A3+B3)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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

    Re: Daily balance sheet + making empty cells blank heeeeeeelp

    Alternatively,

    =IF(AND(A3="",B3=""),"",C2-A3+B3)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

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

    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. #5
    Registered User
    Join Date
    06-20-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Wink 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!!
    Last edited by CRUSROD; 07-10-2012 at 08:11 AM.

  6. #6
    Registered User
    Join Date
    07-10-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Daily balance sheet + making empty cells blank heeeeeeelp

    Quote Originally Posted by Ace_XL View Post
    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

+ 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