Formula for determing what range of numbers a number is in

[Sundance_Kid]

Hi

I have a number and I need to find out which range it is in between. So for example I need to determine is the number equal to or more than 95 but less than 102 and if it is the answer is "X" or else determine if the number is equal to or more than 102 but equal to or less than 110 then the answer is "Y" or if the number is less than 95 or more than 110 the answer should be "Z".

I am able to determine if the number is equal to or more than 95 but less than 102 with the following formula but I want to extend it to included the other range between 102 and 110. =IF(AND(I69>=B69,I69<D69),"X",Z)

95

98

102

105

110

<tbody>
</tbody>

Thanks in advance

 

[Sundance_Kid]

Hi

I have a number and I need to find out which range it is in between. So for example I need to determine is the number equal to or more than 95 but less than 102 and if it is the answer is "X" or else determine if the number is equal to or more than 102 but equal to or less than 110 then the answer is "Y" or if the number is less than 95 or more than 110 the answer should be "Z".

I am able to determine if the number is equal to or more than 95 but less than 102 with the following formula but I want to extend it to included the other range between 102 and 110. =IF(AND(I69>=B69,I69<d69),"x",z)

95

98

102

105

110

<tbody>
</tbody>

Thanks in advance

I don't think my formula came through

=IF(AND(I69>=B69,I69<D69),"X",Z)

I69 being the number and B69 being 95 & D69 being 102.
</d69),"x",z)

 

[oldbrewer]

I have a number and I need to find out which range it is in between. So for example I need to determine is the number equal to or more than 95 but less than 102 and if it is the answer is "X" or else determine if the number is equal to or more than 102 but equal to or less than 110 then the answer is "Y" or if the number is less than 95 or more than 110 the answer should be "Z".
I am able to determine if the number is equal to or more than 95 but less than 102 with the following formula but I want to extend it to included the other range between 102 and 110. =IF(AND(I69>=B69,I69							MYTABLE
95	98	102	105	110			1	Z
							95	X
							102	Y
							111	Z
							999	Z
93	Z
94	Z
95	X
96	X
97	X
98	X
99	X			THE FIRST Z OBTAINED BY
100	X
101	X			=VLOOKUP(A9,MYTABLE,2)
102	Y
103	Y
104	Y
105	Y			or
106	Y
107	Y			=IF(A9<95,"Z",IF(A9<102,"X",IF(A9<111,"Y","Z")))
108	Y
109	Y
110	Y
111	Z
112	Z
113	Z

<colgroup><col><col span="10"></colgroup><tbody>
</tbody>