software

I have one cell that has my begining total...and then another cell that has
the payment and the 3rd cell is the remaining balance my formula is
=SUM(D2,-C3) then i copied all the totals down until the balance is zero when
i enter in a payment then it subtracts and records the new balance but the
new balance shows up in all the cells below.....How do i get the new balance
not show up in all the cells after i enter a payment??? Here is a copy of my
sheet
C colum D colum
Balance:$150.00 $3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010
$3,010Something like in your balance column:

=If(c3=0,quot;quot;,Sum(d2,-c3))

I.e. if payment is zero (blank) , balance column is blank, otherwise show
balance.

HTH

quot;Boomerquot; wrote:

gt; I have one cell that has my begining total...and then another cell that has
gt; the payment and the 3rd cell is the remaining balance my formula is
gt; =SUM(D2,-C3) then i copied all the totals down until the balance is zero when
gt; i enter in a payment then it subtracts and records the new balance but the
gt; new balance shows up in all the cells below.....How do i get the new balance
gt; not show up in all the cells after i enter a payment??? Here is a copy of my
gt; sheet
gt; C colum D colum
gt; Balance:$150.00 $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt; $3,010
gt;