![]() |
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? |
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. |
All times are GMT +1. The time now is 03:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com