• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need a formula to give the total of n months

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
 
Back
Top