Return specific number if Cell between 2 numbers

[eechristaylor]

I have a cell figuring a percentage of a cost, i.e. 28%. I need to write a formula for the following conditions:

If the cell C25 is between 26-35% return 11, 36-45% return 12, 46-55% return 13.

I have if statements for less than 25% and I tried to us IF(AND(C25<35%,C25>26%,"11") but that does not work.

Any help will be appreciated.

 

[Scott Huish]

Make a table like I did in H1:I5 and use VLOOKUP

Book1
	C	D	E	F	G	H	I
1						0
2						0.26	11
3						0.36	12
4						0.46	13
5						0.56
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22	0.35	11
23	0.57	0
24	0.26	11
25
Sheet1

Cell Formulas
Range	Formula
D22:D24	D22	=VLOOKUP(C22,$H$1:$I$5,2)

 

[Peter_SSs]

If the cell C25 is between 26-35% return 11, 36-45% return 12, 46-55% return 13.

Assuming those are the only possible percentage ranges and results, another possibility might be ..

24 12 07.xlsm
	C	D
25	37.0%	12
26	53.2%	13
27	26.0%	11
Percentage Ranges

Cell Formulas
Range	Formula
D25:D27	D25	=10+MATCH(C25,{0.26,0.36,0.46})

 

[kvsrinivasamurthy]

Try.
Assumed for <26% as 10 and for >=56% as 14. Change it as required.

=IF(C25<26%,10,IF(C25<36%,11,IF(C25<46%,12,IF(C25<56%,13,14))))