ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with calculation (https://www.excelbanter.com/excel-discussion-misc-queries/61153-help-calculation.html)

scripttron75

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?

[email protected]

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