Daniel.amos
New Member
Hi All,
Any assistance would be appreciated.
I want a formula that will give me the total for a Number of payments.
Installment1 = 600
Installment2 = Installment1 + 600 + 600
Month 3 = Month 2 + 600 + 600 + 600 = 3600
The installment amount stays the same, just the number of Payments can vary, so I can just enter 10 and it will calculate total after 10 payments.
I can do this in a loop in excel vba but ca t work out how i can do it in a formula.
Thanks
Any assistance would be appreciated.
I want a formula that will give me the total for a Number of payments.
Installment1 = 600
Installment2 = Installment1 + 600 + 600
Month 3 = Month 2 + 600 + 600 + 600 = 3600
The installment amount stays the same, just the number of Payments can vary, so I can just enter 10 and it will calculate total after 10 payments.
I can do this in a loop in excel vba but ca t work out how i can do it in a formula.
Thanks