Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 155
- Office Version
- 365
- Platform
- Windows
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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]95[/TD]
[TD]98[/TD]
[TD]102[/TD]
[TD]105[/TD]
[TD]110[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance
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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]95[/TD]
[TD]98[/TD]
[TD]102[/TD]
[TD]105[/TD]
[TD]110[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance