Multiple IF and Greater And Less in one formula

[AlexIK]

First of all I am pretty new to xls formulas so sorry if my question would sound too easy for someone.
So what I would like to do is the formula with multiple IF and greater/less.
to put it simple 0~7 = 0%
8~9 = 50%
10~19 = 73%
20~49 = 81%
50~99 = 87%
100~299 = 89%
300~ = 91%
Right now I am doing input manually and looking for a help with the formula

 

[SunnyAlv]

Try This

on Cell C1

=IF(B1>300,"91%",IF(B1>100,"89%",IF(B1>50,"87%",IF(B1>20,"81%",IF(B1>10,"73%",IF(B1>7,"50%",IF(B1>0,"0%")))))))

 

[KRice]

Here are some additional ideas. Note that this closes up the gaps between each tier, so the first tier is 0<=x<8, second tier 8<=x<10, and so on:

Book2
	A	B	C	D
1	A	1	0%	0%
2	B	8	50%	50%
3	C	15	73%	73%
4	D	45	81%	81%
5	E	70	87%	87%
6	F	150	89%	89%
7	H	500	91%	91%
Sheet1

Cell Formulas
Range	Formula
C1:C7	C1	=XLOOKUP(B1,{0,8,10,20,50,100,300},{0,50,73,81,87,89,91}/100,,-1,1)
D1:D7	D1	=MAX({0,50,73,81,87,89,91}/100*(B1>={0,8,10,20,50,100,300})*(B1<{8,10,20,50,100,300,9.99E+307}))

 

[StephenCrump]

Same idea as @KRice, but I have interpreted your question differently:

	A	B	C	D	E	F
1	MyValues				MyTable
2	1	0%			0	0%
3	9	50%			8	50%
4	15	73%			10	73%
5	45	81%			20	81%
6	70	87%			50	87%
7	150	89%			100	89%
8	500	91%			300	91%
9
Sheet3

Cell Formulas
Range	Formula
B2:B8	B2	=VLOOKUP(A2,MyTable,2)

Named Ranges
Name	Refers To	Cells
MyTable	=Sheet3!$E$2:$F$8	B2:B8

 

[AlexIK]

Thank you everyone. Didnt even know it could be done in so many different ways. You guys made my day today!

 

[KRice]

We’re happy to help…and welcome to the MrExcel Board.