Help with automating a small process

[knewuser]

Hi, i am trying to automate a series of actions. My goal is to calculate "final score" here for a chosen F9 cell value. 1. First, i will choose a number from the drop down in F9 cell. 2. the "final score" cell will be equal to "initial score" as long as the "position row" value is less than F9 and we have used all the values in "boost factor row". For example, i choose 4 in F9. Then,
I9= I8 because I7<F9
J9= J8 because J7<F9
K9= K8 because K7<F9
Now, L7=>F9, So
L9= I5*L8 because L7>=F9
M9 = J5*M8 because M7>F9
N9 = K5*N8 because N7>F9
O9 = L5*O8 because O7>F9
Now, we no longer have any values for "boost factor"row. So, again
P9 = P8,
Q9= Q8 and so on...

Can anyone please share a formula or tips to implement this ? Thanks in advance.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with couple of steps in excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[knewuser]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with couple of steps in excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Hi, thanks for adding the cross posting and sorry for not following the rules. this is my first post. If there is no use in cross-posting, i am fine for removing it. Otherwise, this is my mini-sheet.

formula.xlsx
	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
4				a	b	c	d	e
5			boost factor	3	4	5	6	7
6	INPUT CELLS
7			position	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
8	Selected start position		initial Score	10	15	20	25	30	35	40	45	50	55	60	65	70	75	80	85	90
9	4		final score	10	15	20	75	120	175	240	315	50	55	60	45	50	55	60	65	70
10	Selected end position
11	12
12
13	Reduction from final score
14	20
15
16
17					I am trying to automate the calculation of final score in row 9 based on the input cells. Currently the final score row has formulas that can manually calculate final score.
18
19
Sheet1

Cell Formulas
Range	Formula
J7:Y7	J7	=I7+1
J8:Y8	J8	=I8+5
I9:K9,Q9:S9	I9	=I8
L9:P9	L9	=L8*I5
T9:Y9	T9	=T8-$F14

Cells with Data Validation
Cell	Allow	Criteria
F9	List	=$L$7:$S$7
F11	List	=$L$7:$Y$7

 

[Fluff]

How about

=IF(I7<$F9,I8,I8*IFERROR(INDEX($I$5:$M$5,I7-$F9+1),1))