Nested IFS Statement - HELP

[chelleross]

I am trying to type an IFS statement that will look at one cell and decide on the answer based on a greater or lesser than decision.

10 sq. in. or below = $7.00
10 - 25 sq. in. = $10.00
25 - 50 sq. in. = $14.00
50 - 75 sq. in. = $17.00
75 - 100 sq. in.= $20.00
100 - 150 sq. in.= $23.00
150 - 200 sq. in.= $26.00
200 sq. in. or higher = $36.00

How would I write the statement?

Data cell
E2 that has 11
E3 that has 26
E4 that has 52
E5 that has 100
E6 that has 179
E7 that has 226


This was my first attempt at something so complex...but does not work.

=IFS(AND(E2<=10, Pricing!$B$2), (E2>10, E2<25, Pricing!$B$3), (E2>25, E2<50, Pricing!$B$4), (E2>50, E2<75, Pricing!$B$5), (E2>75<100, Pricing!$B$6), (E2>100, E2<150, Pricing!$B$7), (E2>150, E2<200, Pricing!$B$8), (E2>200, Pricing!$B$9)

Thanks in advance for your quick help!
Chelle

 

[njimack]

Excel Workbook
	A	B	C	D
1	Sq in	$		55
2	0	7		17
3	11	10
4	26	14
5	51	17
6	76	20
7	101	23
8	151	26
9	201	36
Sheet1

 

[jtakw]

Hi,

Another way:

Excel 2010
	A	B	C	D	E	F
1	Sq in	$				$
2	0	$7.00			9	$7.00
3	11	$10.00			10	$7.00
4	26	$14.00			11	$10.00
5	51	$17.00			26	$14.00
6	76	$20.00			52	$17.00
7	101	$23.00			100	$20.00
8	151	$26.00			179	$26.00
9	201	$36.00			226	$36.00
Sheet8

Cell Formulas
Range	Formula
F2	=LOOKUP(E2,A$2:A$9,B$2:B$9)

F2 formula copied down.

BTW, your Sq. in. Table has overlaps in your OP, both njimack and I are assuming 10 or below = $7, 11 to 25 = $10, 26 to 50 = $14, etc.