Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=400579 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
table | Excel Worksheet Functions | |||
Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
Item wise balance in Pivot Table | Excel Discussion (Misc queries) |