Complicated Formula Question

[mdaniels3423]

I have a complicatedd problem that I am working on.

1 want to have a cell where I have a number and be able to take that number and Add to it itself + a percentage, however the problem is taht I need to be able to do this multiple times

Example.

Take 2048 as main number with 10% as additive number and do this 5 times.

i.e. 2048
+
2048*10% (204.8) = 2252.8
+
2252.8 *10% = 2457.6
+
2457.6 * 10%= 2662.4
+
2662.4*10%=2867.2
=
12288

The data in the cells would be
A1 = 2048
A2 = 10%
A3 = 5

I need this formula to be able to change as I change the numbers (i.e. if I use 6 in A3, it should add an additional time)

I have tried and I cannot figure out this formula.

Any help is appreciated.

 

[lenze]

Hi and welcome to the Board
I can't think of a formula right off hand, but this can be done with code. Is that an option?

lenze

 

[dave3009]

is it

Excel Workbook
	E	F	G	H
1	2048	10%	5	3298.324
Sheet3

Excel 2007

Cell Formulas
Range	Formula
H1	=E1*POWER(F1+1, G1)

 

[VoG]

This may be more by luck than judgment

=A1*(1^A2*(A3+1))