Remember Me?

#### Menu

#1
October 28th 04, 01:38 AM
 kidd Posts: n/a
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

#2
October 28th 04, 02:35 AM
 garfield-n-odie Posts: n/a

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

#3
October 28th 04, 03:07 AM
 Myrna Larson Posts: n/a

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

#4
October 28th 04, 03:41 AM
 kidd Posts: n/a

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

#5
October 28th 04, 04:54 AM
 kidd Posts: n/a

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM Richard F Excel Discussion (Misc queries) 1 January 20th 05 09:56 PM circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM

All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017