Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bobby B
 
Posts: n/a
Default 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   Report Post  
BekkiM
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM
how do i create a running balance on checkbook register mic Excel Discussion (Misc queries) 5 August 4th 05 08:53 PM
how do i add cells in checkbook register template with formulas? nlc Excel Worksheet Functions 0 June 28th 05 03:57 AM
Spreadsheet Dilemma msbates2004 Excel Discussion (Misc queries) 1 May 27th 05 02:55 AM
How do I create a checkbook register? Cumquat New Users to Excel 2 January 2nd 05 12:57 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"