| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i calculate a running payoff amount?
I'm doing an amortization.
I have everything working except I want to do a 'payoff' cell.... The payoff will be the sum of payments plus the principal balance. How can I have this cell update and change as new payments are made? IE.... if 5 pmts are made, payoff is sum of 5 payments plus the principal balance. If 6 pmts are made, its the sum of 6 payments plus the new principal balance. I only want to count the principal balance if there is a corresponding payment, if there is not payment then payoff stops at the last payment made |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i calculate a running payoff amount?
If I read this right something like the following formula might work
=IF(ISBLANK(A13),"",SUM($A$10:A13)+$B$13) if your payments start in A10 and continue down the A column and the principla is in B13 as you copy down the formula it is anchored at A10 but the A13 will continue to incriment down Hope this helps David "phooey" wrote: I'm doing an amortization. I have everything working except I want to do a 'payoff' cell.... The payoff will be the sum of payments plus the principal balance. How can I have this cell update and change as new payments are made? IE.... if 5 pmts are made, payoff is sum of 5 payments plus the principal balance. If 6 pmts are made, its the sum of 6 payments plus the new principal balance. I only want to count the principal balance if there is a corresponding payment, if there is not payment then payoff stops at the last payment made |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i calculate a running payoff amount?
some works... some doesn't.. probably me...
heres what I'm looking for.. the payoff is the sum of the payments made plus the principal balance (after payments). I have the spreadsheet working to figure the rest, but I want the 'payoff' to be calculated in one static field. I can send you what I have and maybe that might help explain? "dkinn" wrote: If I read this right something like the following formula might work =IF(ISBLANK(A13),"",SUM($A$10:A13)+$B$13) if your payments start in A10 and continue down the A column and the principla is in B13 as you copy down the formula it is anchored at A10 but the A13 will continue to incriment down Hope this helps David "phooey" wrote: I'm doing an amortization. I have everything working except I want to do a 'payoff' cell.... The payoff will be the sum of payments plus the principal balance. How can I have this cell update and change as new payments are made? IE.... if 5 pmts are made, payoff is sum of 5 payments plus the principal balance. If 6 pmts are made, its the sum of 6 payments plus the new principal balance. I only want to count the principal balance if there is a corresponding payment, if there is not payment then payoff stops at the last payment made |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
| Credit Cards, time in months to payoff and payoff amount | Excel Worksheet Functions | |||
| return payoff after "X" amount of payments | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
