Help with calculation

S

scripttron75

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?
 
J

joeu2004

scripttron75 said:
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?
Click to expand...

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.
 
Top