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
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.
Highlighted
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
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies