Closed Thread
Results 1 to 2 of 2

table w/running balance

  1. #1
    Donna Cas
    Guest

    table w/running balance

    need an excel table. needs the starting balance, the date, vendor name,
    amount and have it deducted from the running balance, very simple like a
    check book.

    thank you
    Donna

  2. #2
    Registered User
    Join Date
    09-16-2003
    Location
    Waiau Pa NZ
    Posts
    81
    column a .....date
    column b .....name
    column c .....amount
    column d .....balance

    start in row 1 with headings
    row 2 with the opening balance in D2
    enter in D3 =if(C3="","",D2-C3) this means in plain language

    if cell c3 is empty show d3 to be empty, otherwise is c3 has a value
    show the baance in D3

    hover over the right hand bottom corner of cell D3
    the mouse pointer will change to a "+" sign
    left click and drag down as far as you want to go.

    hope that helps
    Greetings from New Zealand
    Bill Kuunders

Closed 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