CharlieMike73
Programmer
I am tring to create a worksheet to track my repayment on a loan, what I have so far is three columns (A,B,C) like so:
Payments:
Date Amount Paid Balance
19-Aug-05 $50.00 $350.00
19-Sep-05 $100.00 $250.00
19-Oct-05 $150.00 $100.00
What I want it to do is when a new payment is entered on the next line, it takes the previous lines balance and the subtracts the current lines ammount paid and puts the result in column C.
I was able to do this with the following:
=SUM(C21-B22)
But I get the same value repeated for all the following lines which are still blank, how do I make it populate the balance field (C) on each line ONLY when a value is supplied in column B on that line?
Do you knw what I mean???
I did try the SUMIF command but that did not like the use of null or >0 in my condition!
Regards,
Charlie
Payments:
Date Amount Paid Balance
19-Aug-05 $50.00 $350.00
19-Sep-05 $100.00 $250.00
19-Oct-05 $150.00 $100.00
What I want it to do is when a new payment is entered on the next line, it takes the previous lines balance and the subtracts the current lines ammount paid and puts the result in column C.
I was able to do this with the following:
=SUM(C21-B22)
But I get the same value repeated for all the following lines which are still blank, how do I make it populate the balance field (C) on each line ONLY when a value is supplied in column B on that line?
Do you knw what I mean???
I did try the SUMIF command but that did not like the use of null or >0 in my condition!
Regards,
Charlie
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
