Thread: [SOLVED] need help on formulas for balance function (accounting)

hi folks,

Need help on the best formula to make sort of account detail
i.e.

date description CREDIT DEBIT BALANCE
1/11 balance from october 35000
5/11 income 4750 39750
7/11 expense 450 39300

what formula can I put in the BALANCE Row, so that when I put certain value to CREDIT row the balance will increase.
And when I put certain value to DEBIT row, the balance will decrease

example file are attached

Thanks

Formula in E3 copied down:

=$E$2+SUM($C$3:C3)-SUM($D$3:D3)

Dom

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Nothing to stop uou editing it now & then mark it solved