Balance as used in balancing a checkbook

Copper Contributor

Hi,

I am new at using Excel.  I would like to set up a worksheet where, in addition to date column and description column, I can add a deposit in deposit column or subtract a payment in payment column and get a balance in balance column for each entry, as you would in balancing a checkbook.  Thank you in advance for your help.

2 Replies
Hi, here is a template provided by Microsoft that will give you a starter for 10. If you get stuck further then there are plenty of excel experts on here to help you.
Assuming Date, Description, Deposit, Payment, and Balance are in A1:E1, the formula starting in E2 is:
=SUM(E1,C2,-D2)