Need help making a series

Hello!
I need some help making a series of numbers

For example:

Lets say I have someone put in the number 6.
I need the series to be translated to 2100
100 + 200 (=300) + 300 (=600) + 400 (=1000) + 500 =(1500) + 600(=2100)
I need it to constantly increase by 100 extra number

I need the same thing done for an increase of 50
50 + 100 (=150) + 150 (300) + 200 = (500) + 250 (750) + 300 (1050)

Then I need those numbers to add together and multiply by a set number for example 90

The way I am looking to input it is for example in C1 Enter number 6 (series), and in C2 Enter number 6 (Series) they become 2100+ 1050= 3150 * 90

I hope that is all the information needed to help me
thank you very much

just the final sums so if i enter 6 for part 1 and 6 for part 2 .. i just want to see the final answer of 3150

No it is correct, after 10 the series starts by 50 instead of 100.
So as in the example i had, 10 would be 88000
That is why i said it may not be possible to have it all in one cell.

Originally Posted by newdoverman

This is my interpretation of the problem:

	A	B	C	D
1	# of numbers	Base #
2	10	100	5500	=((A2+1)/2)*A2*B2
3	10	50	2750
4			8250
5
6	10	150	8250	=((A2+1)/2)*A2*B2

Your first example given is linear but the second example is exponential. Both of these are linear. What do you really want?

They are the same two things, I was just making it less complicated in the first example where I put them separately, I was asking if its possible to make one equation in one cell, without having to make a mess. I can always hand write it, but im trying to make a little calculator for a specific thing for other people to use.

Chemist! thank you very much what you did helped me, instead of cells I just plugged in 10 and 11 into the equation
((((((C6*(10/2*(2*100+(10-1)*100)+11/2*(2*50+(11-1)*50)))))))/2*(90)/((((C3+((C4-C3))/10)))*((((1+(E3/10)+(E4/10)+(E5*0.005)+(E6/10))))))/(1+G3/100))

That's basically my equation and it gives me my answer I want in seconds.. I always have trouble doing this next part.
Could you help me convert this answer- by keeping it in the same cell, and multiplying this answer into minutes.. the final answer of this equation above the answer comes out to 11161.1 seconds.. I would like it to come out into minutes:hours:seconds

Is it possible to add something to that equation to make it come out to minutes:hours:seconds? Or would I need to Keep it as 1 cell and in the next cell make an equation for hour minutes and seconds .. that way it has something to multiply

Thank you again

Hoping its possible to put hours minutes seconds into that somehow...can't wait to see a reply, hopefully it is a good one haha! anxious

Originally Posted by ChemistB

What you have now is 1 second as the unit of measure. Excel uses 1 day as the unit of measure.
So, divide your seconds by number of seconds in a day (60*60*24) and then format the cell with custom format
[hh]:mm:ss so it shows as hours:min:Sec. The [] around hh means to keep it in hours even if it's over 24.

the formula would be
((((((C6*(10/2*(2*100+(10-1)*100)+11/2*(2*50+(11-1)*50)))))))/2*(90)/((((C3+((C4-C3))/10)))*((((1+(E3/10)+(E4/10)+(E5*0.005)+(E6/10))))))/(1+G3/100))/(60*60*24)

Hey Chemist, I am having trouble sending a private message, when i look in the sent section nothing shows up, I put an attachment here, i hope it is easy to understand. Any questions please private message me.

If you change the formula in AA6 of Chemist's example workbook to:
=TIME(0,0,SUM(AA4:AA5))

this will change your seconds into a time value, you can then format this as a time with HH:MM:SS to get the answer displayed as you want.