Help needed on calculating inflation percentage

Here is what I'm trying to do with a Excel formula. I need to add simple inflation percentage for a single year to a value, for example, if the value is 1000 and the inflation percent is 10, the value after one year is 1100. But I need to continue adding only the same percent to that value to provide a cumulative total. For example, after the second year the total would be 1100 plus 1200 (1100 + 100), which equals 2300. After the third year the total would be 1100 + 1200 +1300, which equals 3600. The number of years is determined by an input field, as is the inflation rate. I desperately need help in making this type of calculation.

Thanks

Ok...your description isn't exactly an inflation model...but to do exactly what you described you want to multiply your base amount (1000) by your years and add a factorial amount of the "inflation".

cell a1 = base amount (1000)
cell a2 = inflation (10 as a whole number equaling 10%)
cell a3 = years

=fact(a3)*(a1*(a2/100))+(a1*a3)

Try this:

A1 = initial value
A2 = inflation percent
A3 = num of yrs
A4 = A1*A3+COMBIN(A3+1,2)*A2/100*A1

I got it to work using one of the formulas. I very much appreciate the help.

I deleted this post because I started a new thread with the content.

I still cannot get the formula which calculates a cumulative total over 15 years starting with $12,183 using 3.8% inflation rate.