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