Help with IF AND statement please

[Nessi]

Hi there
hoping you can please help with an IF AND STATEMENT please....

I'm trying to create a formula to return the following text based on %\ numbers:

if less than 90%, type '<90%'
if >= 90% and <=100%, type '90% - 100%'
If >= 100.01% and <=110%, type '100% - 110%'
if >110%, type '>110%'

Assuming the data is in column A1, A2 so on, what can I do? I'm completely lost and the number of brackets always confuse me ?

I wiuld be be truly Grateful for any help!

 

[Dave Patton]

Consider a Lookup

Excel 2010
	A	B	C	D	E	F
1	60%	<90%'
2		<90%'	self-contained		0.000%	<90%'
3		<90%'			90.000%	'90% - 100%'
4		<90%'	self-contained		100.001%	'100% - 110%'
5					110.001%	'>110%'
6
6a

Cell Formulas
Range	Formula
B1	=LOOKUP(A1,E2:F5)
B2	=LOOKUP(A1,{0,"<90%'";0.9,"'90% - 100%'";1.00001,"'100% - 110%'";1.100001," '>110%'"})
B3	=IF(A1>E5,F5,IF(A1>=E4,F4,IF(A1>=E3,F3,IF(A1>=E2,F2,0))))
B4	=IF(A1>1.10001," '>110%'",IF(A1>=1.00001,"'100% - 110%'",IF(A1>=0.9,"'90% - 100%'",IF(A1>=0,"<90%'",0))))