ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   need formulas (https://www.excelbanter.com/setting-up-configuration-excel/262376-need-formulas.html)

 Kimberly April 25th 10 05:31 PM

need formulas

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 ______

 Bob Phillips[_4_] April 25th 10 05:43 PM

need formulas

Depends upon the type of checkbox. Give us some details.

--

HTH

Bob

"Kimberly" wrote in message
...
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 ______

 Matt's Dad April 25th 10 08:35 PM

need formulas

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

"Kimberly" wrote in message
...
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 ______

 All times are GMT +1. The time now is 12:13 PM.