Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet like checkbook register
I'd like to create a simple s/s to add deposits and deduct sums as a
checkbbok register and keep a running balance..say in differant columns. Help with that. Thanks. |
#2
|
|||
|
|||
Try this:
A B C D E 1 Check# Description Withdrawal Deposit Balance 2 N/A Opening Balance $0.00 $0.00 $100.00 3 001 Bob's BBQ Pit $10.50 $0.00 =E2-C3+D3 Copy the formula in E3 down for as many rows as you need. "Bobby B" wrote: I'd like to create a simple s/s to add deposits and deduct sums as a checkbbok register and keep a running balance..say in differant columns. Help with that. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
how do i add cells in checkbook register template with formulas? | Excel Worksheet Functions | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
How do I create a checkbook register? | New Users to Excel |