If statement between ranges

[markdoc5]

Hey All, - hopefully someone can offer some assistance for this, before i lose my hair!

What im looking for is, if i type a percentages in No 1 2 or 3 - depending on that percentage it will give me the weightings percentile to the right (hopefully that makes some sense)

Book1
	B	C	D	E	F	G	H	I	J	K	L	M
2
3	No1				Weight No1					No1 percentile	No2 percentile	No3 percentile
4	96%				based on B4 it will show K4/k5/k6 or k7					110% Or Above	13% or above	85% and below
5										Between 100%- 109%	between 11%-12%	between 85% - 90%
6	No1				Weight No1					Between 95% - 99%	between 9% - 10%	between 90% - 95%
7	14%				?					94% or below	9% or below	95% and above
8
9	No1				Weight No1
10	98%				?
11
Sheet1

 

[Kerryx]

Book2
	B	C	D	E	F	G	H
4	No1				Weight No1
5	96.00%				Between 95% - 99%
6
7	No1				Weight No1
8	14.00%				13% or above
9
10	No1				Weight No1
11	98.00%				85% and below
12
Sheet1

Cell Formulas
Range	Formula
F5	F5	=IF(OR(B5<=94%),K8,IF(B5>110%,K5,IF(AND(B5>=100%,B5<=109%),K6,IF(AND(B5>95%,B5<=99%),K7,))))
F8	F8	=IF(OR(B8<=9%),L8,IF(B8>13%,L5,IF(AND(B8>=11%,B5<=12%),L6,IF(AND(B8>9%,B8<=10%),L7,))))
F11	F11	=IF(OR(B11<=95%),M8,IF(B11>85%,M5,IF(AND(B11>=85%,B11<=90%),M6,IF(AND(B11>90%,B11<=95%),M7,))))

 

[markdoc5]

Book2
	B	C	D	E	F	G	H
4	No1				Weight No1
5	96.00%				Between 95% - 99%
6
7	No1				Weight No1
8	14.00%				13% or above
9
10	No1				Weight No1
11	98.00%				85% and below
12
Sheet1

Cell Formulas
Range	Formula
F5	F5	=IF(OR(B5<=94%),K8,IF(B5>110%,K5,IF(AND(B5>=100%,B5<=109%),K6,IF(AND(B5>95%,B5<=99%),K7,))))
F8	F8	=IF(OR(B8<=9%),L8,IF(B8>13%,L5,IF(AND(B8>=11%,B5<=12%),L6,IF(AND(B8>9%,B8<=10%),L7,))))
F11	F11	=IF(OR(B11<=95%),M8,IF(B11>85%,M5,IF(AND(B11>=85%,B11<=90%),M6,IF(AND(B11>90%,B11<=95%),M7,))))

Your are a god among men and i thank you !

I don't know why i tried to over complicate it with some of the formulas i tried haha