ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Spreadsheet like checkbook register (https://www.excelbanter.com/new-users-excel/48000-spreadsheet-like-checkbook-register.html)

Bobby B

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.

BekkiM

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.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com