View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.