close

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?

quot;scripttron75quot; wrote:
gt; I have an excel worksheet that I use for finances.
gt; I have to cells one is a Paid cell and the other is a
gt; Balance cell. I want to take the Paid cell and Minus
gt; it from the Balance cell and have the Balance cell
gt; reflect the change in the amoutn paid how can I do
gt; 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 quot;obviousquot;. 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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()