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
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.
Highlighted
Assuming Date, Description, Deposit, Payment, and Balance are in A1:E1, the formula starting in E2 is:
=SUM(E1,C2,-D2)