73-87chevytrucks.com
General Site Info => General Discussion => Topic started by: reload on August 15, 2011, 11:38:32 pm
-
For the life of me I can't remember what this is called. I believe there is a formula to represent it.
Lets say I have a range of numbers or steps
1 - 100
Each step adds value of 25
With an initial value of 50.
So
Step 1 = 50
Step 2 = 75
Step 3 = 100
Step 4 = 125
Step 5 = 150
And so on
What is that called?
-
you mean like a "number sequence pattern"
-
you mean like a "number sequence pattern"
YES! Let try something.
-
this might help
http://www.mathsisfun.com/numberpatterns.html
-
what are we going to try ;)
-
what are we going to try ;)
Trying to write this in excel
-
write what
-
I want to map this in excel, using the example in the OP
-
This may be my answer. Trying it meow.
http://www.get-digital-help.com/2010/01/24/create-number-sequences-in-excel-2007/
-
If you need a formula
try this;
50+(25 x's (Step#-1)) = X
Substitute values as needed. If this is homework use proper symbols and letters to represent the equation.
-
If you need a formula
try this;
50+(25 x's (Step#-1)) = X
Substitute values as needed. If this is homework use proper symbols and letters to represent the equation.
Ok still use this in the same format just reference cells where you enter your values with the "$" symbol
-
Okay, I am closer, but here is the issue -
Using a growth trend I can quickly see that step 100 will equal 2525. But now I need to show the total value spent per step.
50
75 =125
100 = 225
125 = 350
150 = 500
175 = 675
and so on.
-
Its not homework, well sorta. I want the values to project total time to total cost. Sadly this is for game, I am trying to figure out based on a absolute income how much and how long it will take to achieve the goal; that is step 100.
It also doesn't help that I am fighting my ambien to figure this out :P
-
try to use a "linear" trend as this is a linear equation.
Or post back your formula and maybe someone can fix it.
-
You also need to enter a "min" and "max" for 1-100 to be to get a n/a value outside of the parameters if you want to be technical about it, otherwise don't worry about it.
-
I think I need to declare a variable.
Because as it sits would be like this:
A1 = 50 B1 = [blank]
A2 = 75 B2 = 125
A3 = 100 B3 = 225
A4 = 125 B4 = n
How can I compute the next blank cell in col B using the value of the current cell of col A + the previous of col B?
-
Got it.
50
75 125
100 225
125 350
150 500
175 675
200 875
225 1100
250 1350
275 1625
300 1925
325 2250
350 2600
375 2975
400 3375
425 3800
450 4250
475 4725
500 5225
525 5750
550 6300
575 6875
600 7475
625 8100
650 8750
675 9425
700 10125
725 10850
750 11600
775 12375
800 13175
825 14000
850 14850
875 15725
900 16625
925 17550
950 18500
975 19475
1000 20475
1025 21500
1050 22550
1075 23625
1100 24725
1125 25850
1150 27000
1175 28175
1200 29375
1225 30600
1250 31850
1275 33125
1300 34425
1325 35750
1350 37100
1375 38475
1400 39875
1425 41300
1450 42750
1475 44225
1500 45725
1525 47250
1550 48800
1575 50375
1600 51975
1625 53600
1650 55250
1675 56925
1700 58625
1725 60350
1750 62100
1775 63875
1800 65675
1825 67500
1850 69350
1875 71225
1900 73125
1925 75050
1950 77000
1975 78975
2000 80975
2025 83000
2050 85050
2075 87125
2100 89225
2125 91350
2150 93500
2175 95675
2200 97875
2225 100100
2250 102350
2275 104625
2300 106925
2325 109250
2350 111600
2375 113975
2400 116375
2425 118800
2450 121250
2475 123725
2500 126225
2525 128750
-
Set the next blank cell in Col B as "= (A3+B2)" and repeat growth trend.
-
Was going to say reference it without the "$" and it should move down the column plus write a new formula
-
Was going to say reference it without the "$" and it should move down the column plus write a new formula
Yep yep. The sad part is, I own my own business as a website developer, I know and LOVE php, html, javascript, and css but for the life of me I never played around with Excel.
-
I'm convinced someone could work with it a lifetime and never learn all of its capabilities. I have written several formulas 6-8 lines long for payroll calculations etc. The challenge is kind of fun getting the formula to work. Once you get it though it's nice to make calculators for mortgage or car payments or retirement accts. I think the key is to learn well above the level you plan to use it and then everything seems pretty basic.
-
i make our count sheets on excel and i share them with everyone but it only takes one miss click or idiot to screw it all up lol sorry i had to get off before and just got back on didnt mean to bail on you but glad you got it figured out
-
I love it! I use several "back pages" that when data is entered it automatically adjusts the "cover page"
You can pretend it's taken ages to produce documents etc when it can do it all for you ;D