Home

Balance as used in balancing a checkbook

%3CLINGO-SUB%20id%3D%22lingo-sub-360717%22%20slang%3D%22en-US%22%3EBalance%20as%20used%20in%20balancing%20a%20checkbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360717%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20new%20at%20using%20Excel.%26nbsp%3B%20I%20would%20like%20to%20set%20up%20a%20worksheet%20where%2C%20in%20addition%20to%20date%20column%20and%20description%20column%2C%20I%20can%20add%20a%20deposit%20in%20deposit%20column%20or%20subtract%20a%20payment%20in%20payment%20column%20and%20get%20a%20balance%20in%20balance%20column%20for%20each%20entry%2C%20as%20you%20would%20in%20balancing%20a%20checkbook.%26nbsp%3B%20Thank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360742%22%20slang%3D%22en-US%22%3ERe%3A%20Balance%20as%20used%20in%20balancing%20a%20checkbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360742%22%20slang%3D%22en-US%22%3EAssuming%20Date%2C%20Description%2C%20Deposit%2C%20Payment%2C%20and%20Balance%20are%20in%20A1%3AE1%2C%20the%20formula%20starting%20in%20E2%20is%3A%3CBR%20%2F%3E%3DSUM(E1%2CC2%2C-D2)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360724%22%20slang%3D%22en-US%22%3ERe%3A%20Balance%20as%20used%20in%20balancing%20a%20checkbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360724%22%20slang%3D%22en-US%22%3EHi%2C%20here%20is%20a%20template%20provided%20by%20Microsoft%20that%20will%20give%20you%20a%20starter%20for%2010.%20If%20you%20get%20stuck%20further%20then%20there%20are%20plenty%20of%20excel%20experts%20on%20here%20to%20help%20you.%3C%2FLINGO-BODY%3E
Highlighted
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
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 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