Home

Balance as used in balancing a checkbook

ctdillard126
Occasional Visitor

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
Highlighted
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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies