More Than 7 Nested

[TommyKay44]

I'm trying to automate adding amounts to an employee's hourly rate of pay depending on the amount of business (sales) they did that week. Here's a pic of the 9 different levels:

I have it working fine with a nested IF formula for digits 1-7 with the formula below:
=IF(H10=1,(F10*0.5)+((G10*0.5)*1.5),IF(H10=2,(F10*2)+((G10*2)*1.5),IF(H10=3,(F10*5)+((G10*5)*1.5),IF(H10=4,(F10*7)+((G10*7)*1.5),IF(H10=5,(F10*10)+((G10*10)*1.5),IF(H10=6,(F10*12)+((G10*12)*1.5),IF(H10=7,(F10*15)+((G10*15)*1.5),0)))))))

My clients using it and, fortunately, hasn't needed levels 8 and 9 yet. An IFS formula seems ideal to use but when trying to change it to an IFS for levels 1-7, I can't get it to work. What am I doing wrong in the IFS formula below?
=IFS(H10=1,(F10*0.5)+((G10*0.5)*1.5),H10=2,(F10*2)+((G10*2)*1.5),H10=3,(F10*5)+((G10*5)*1.5),H10=4,(F10*7)+((G10*7)*1.5),H10=5,(F10*10)+((G10*10)*1.5),H10=6,(F10*12)+((G10*12)*1.5),H10=7,(F10*15)+((G10*15)*1.5),0)

Thank you in advance for any help I can get on this

 

[JamesCanale]

How about leave the table and use a range lookup:

Mr Excel Playground 3.xlsm
	G	H	I	J	K	L
1	Level 1	$ -	$ 0.50		$ 8,200.00	sales
2	Level 2	$ 3,500.00	$ 2.00		$ 7.00	bonus
3	Level 3	$ 5,000.00	$ 5.00
4	Level 4	$ 7,500.00	$ 7.00
5	Level 5	$ 10,000.00	$ 10.00
6	Level 6	$ 13,500.00	$ 12.00
7	Level 7	$ 15,000.00	$ 15.00
8	Level 8	$ 17,000.00	$ 17.00
9	Level 9	$ 20,000.00	$ 20.00
Sheet18

Cell Formulas
Range	Formula
K2	K2	=VLOOKUP(K1,H1:I9,2,TRUE)

 

[Fluff]

Hi & welcome to MrExcel.
A lookup table would be the best option, but another way is like

=(F10*CHOOSE(H10,0.5,2,5,7,10,12,15))+(G10*CHOOSE(H10,0.5,2,5,7,10,12,15)*1.5)

 

[TommyKay44]

How about leave the table and use a range lookup:

Mr Excel Playground 3.xlsm
	G	H	I	J	K	L
1	Level 1	$ -	$ 0.50		$ 8,200.00	sales
2	Level 2	$ 3,500.00	$ 2.00		$ 7.00	bonus
3	Level 3	$ 5,000.00	$ 5.00
4	Level 4	$ 7,500.00	$ 7.00
5	Level 5	$ 10,000.00	$ 10.00
6	Level 6	$ 13,500.00	$ 12.00
7	Level 7	$ 15,000.00	$ 15.00
8	Level 8	$ 17,000.00	$ 17.00
9	Level 9	$ 20,000.00	$ 20.00
Sheet18

Cell Formulas
Range	Formula
K2	K2	=VLOOKUP(K1,H1:I9,2,TRUE)

The actual sales ranges are basicaly just a a key diagram to lookup what level # to put in the cell in the H column. I probbably shouldn't have put it on my question. Here's a pic of it working with the nested formula addressing only levels 1-7:

Are IFS formulas best used for when text is involved?

 

[TommyKay44]

Sorry. I'm new at this forum. I meant to reply the same thing to Fluff as I did to James Canale. The sales range table wasn't really relevant. Here's the formula working with the 7 levels nested:

=IF(H10=1,(F10*0.5)+((G10*0.5)*1.5),IF(H10=2,(F10*2)+((G10*2)*1.5),IF(H10=3,(F10*5)+((G10*5)*1.5),IF(H10=4,(F10*7)+((G10*7)*1.5),IF(H10=5,(F10*10)+((G10*10)*1.5),IF(H10=6,(F10*12)+((G10*12)*1.5),IF(H10=7,(F10*15)+((G10*15)*1.5),0)))))))

The only two levels left are 8 (+$17.00) and 9 (+$20.00)

 

[Fluff]

Did you try either of the suggestions?