View Single Post
  #1   Report Post  
kidd
 
Posts: n/a
Default Need Formula Help


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