how do i add a formula to a cell that will add or subrtact from d.

  • Thread starter Thread starter Norma
  • Start date Start date
N

Norma

I am doing a finance spreadsheet. It's set up like a checkbook transaction
register. To the far right, I have the balance box. I have a deduction cell
(I) and a deposit cell (K). I have it to where there is a transaction and I
enter the amount on cell (I), it automatically deducts that amount from the
current balance. I want to know if I can have a formula that will add the
deposit I enter on (K) and add it to current balance.
 
Say the balance column is column Z. In Z100, for example:

=Z99-I100+K100

So we get the balance from the row above and apply the debit/credits.
 
Assuming the balance column is column L.

The current balance is the previous balance minus any current debits plus
any current deposits.

So, if you have this data...

-----A-------B--------C---
1--Debits...Deposit...Balance
2--------------------5000
3--100------500----

The current balance formula in C3 would be:

=IF(COUNT(A3:B3),C2-A3+B3,"")
 
Back
Top