ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need Formula Help (https://www.excelbanter.com/excel-worksheet-functions/5174-re-need-formula-help.html)

kidd

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


garfield-n-odie

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



Myrna Larson

What you have are describing is (the sum of digits from 1 to N) * 200.

The equation for the sum of the digits is (N+1)*N/2.

The logic is very clever. Create pairs by selecting 2 numbers from the
original N values, but don't do it at random: do it by pairing 1 with N, 2
with N - 1, 3 with N - 2, etc.

Note that the sum of each pair is N + 1 (e.g. 5 + N - 4 = N + 1)

So, if you know how many pairs there are, the total is (N+1) * number of
pairs. The number of pairs = N/2.

So the sum of the digits from 1 through N, inclusive is (N+1)*N/2

If you put N in cell C1, the formula for A1 is

=200*C1/2*(1+C1)


On Wed, 27 Oct 2004 19:38:04 -0500, 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


garfield-n-odie thanks SO MUCH YOUR THE BEST :)


--
kidd
------------------------------------------------------------------------
kidd's Profile: http://www.excelforum.com/member.php...o&userid=15799
View this thread: http://www.excelforum.com/showthread...hreadid=200316


kidd


I have my entire file now complete and everything work perfectly but I
need this to be on the web where people enter 2 numbers in 2 cells and
then the rest is figured out for them. When I save as webpage it shows
up but no one can enter text in the 2 cells I need them too. Can anyone
help????


--
kidd
------------------------------------------------------------------------
kidd's Profile: http://www.excelforum.com/member.php...o&userid=15799
View this thread: http://www.excelforum.com/showthread...hreadid=200316



All times are GMT +1. The time now is 09:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com