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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks