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,010

Something like in your balance column:

=If(c3=0,"",Sum(d2,-c3))

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

HTH

"Boomer" wrote:

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,010