+ Reply to Thread
Results 1 to 4 of 4

running balance with blank cells under empty field

  1. #1
    Registered User
    Join Date
    02-03-2010
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    9

    running balance with blank cells under empty field

    hi guys

    I made the following running balance

    column A is deposits
    column B is withdrawal
    Column C is balance


    i used the following formulas

    C1 =SUM(A1,-B1)
    C2 =SUM(C1,A2-B2)
    C3 =SUM(C2,A3,-B3)
    etc

    Column C keep showing balance data even if A2, B2 are empty.

    I am unable to find a formula for C3, C4 etc to stay blank until value gets entered in (A2 or B2) (A3 or B3) etc.

    thanks again as this is great help

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208

    Re: running balance with blank cells under empty field

    Try this in C2, and copy down:

    =IF(AND(A2="",B2=""),"",C1+A2-B2)

    HTH,
    Jason

  3. #3
    Registered User
    Join Date
    02-03-2010
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: running balance with blank cells under empty field

    Jason, thanks, it works like a charm
    and thanks for the quick reply, this forum is great

  4. #4
    Registered User
    Join Date
    03-15-2016
    Location
    Pleasant Hill, California
    MS-Off Ver
    Prof 2010
    Posts
    1

    Re: running balance with blank cells under empty field


    Disappointed. I tried Jason's solution for a check register. The last line's running balance reproduces downwards endlessly.
    I double verified the formula copy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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