need formulas

K

Kimberly

I am setting up a checkbook. How do I do credit column to credit balance and
debit column to debit balance on that specific row? So when I click on
balance for that row it automatically gives current balance?

Credit Debit Balance
50.00
50.00 _____
25.00 ______
 
M

Matt's Dad

Is this your goal:
A B C
Row Credit Debit Balance
1 50
2 50 100
3 25 75

If so, your formula is Prior Balance + Current Credit - Currnet Debit

C2 is =C1+A2-B2
C3 is =C2+A3-B3

On row 2 your debit column is blank, which evaluates to zero in the above
formula so 50 starting balance plus 50 credit minus 0 debit equals 100 new
balance.

Hope this helps.

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ref in two worksheets 1
Checking Register 3
excel 2003 1
balance sheet problem 3
Running Balance Query 2
The If function 4
Query Help.. Creating a running Total Field????? 8
How do I query a calculated control? 1

Top