Hi, kidd. You are describing an arithmetic series in the form of
n*(n+1)*100. So if the value n is in cell A1, then the formula in C1 would
be =A1*(A1+1)*100.
"kidd" wrote:
I am trying to make a formula that adds the amount at 200 and then the
amount if it double and triples without a limit.
Example: 1=200 /2 = 200+400/ 3 = 200+400+600/ 4 = 200+400+600+800 / 5
= 200+400+600+800+1000/ 6 = 200+400+600+800+1000+1200
If they enter in A1 the number 4
then in C1 then answer should be 2000
If they enter in A1 the number 6
then in C1 the answer should be 4200
Can anyone HELP ME PLEASE
--
kidd
------------------------------------------------------------------------
kidd's Profile: http://www.excelforum.com/member.php...o&userid=15799
View this thread: http://www.excelforum.com/showthread...hreadid=200316