Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with calculation
I have an excel worksheet that I use for finances. I have to cells one is a
Paid cell and the other is a Balance cell. I want to take the Paid cell and Minus it from the Balance cell and have the Balance cell reflect the change in the amoutn paid how can I do this, what is the function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with calculation
"scripttron75" wrote:
I have an excel worksheet that I use for finances. I have to cells one is a Paid cell and the other is a Balance cell. I want to take the Paid cell and Minus it from the Balance cell and have the Balance cell reflect the change in the amoutn paid how can I do this, what is the function? If B1 contains your previous balance (after payments) and A2 contains your payment for the current period, then B2 (the current balance after payments) can be: =B1-A2 Copy that down. That seems a little "obvious". So I wonder if I misunderstood your need. If that is the case, a concrete example might help, complete with cell references (A1, A2, B1, B2, etc) and the values that you want to see. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |