Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add a formula to a cell that will add or subrtact from d.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add a formula to a cell that will add or subrtact from d.
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. -- Gary''s Student - gsnu201003 "Norma" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add a formula to a cell that will add or subrtact from d.
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,"") -- Biff Microsoft Excel MVP "Norma" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |