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.
- Aug 14 Mon 2006 20:09
Help with calculation
close
全站熱搜
留言列表
發表留言