Slecting the inbetween values

[lprabhu1107]

Hi,

I have a range of values like 20 -25 with 20 in column a1 and 25 in column b1. In column C1 this range is defined as YA. I have a lot of these ranges in Column A and B with definitions in column C. I have to check if 22 falls in beteen 20 and 25 and if true, i should get the result as YA.

kindly assist me with excel formula to solve this

Prabhu

 

[stilesbn]

This should do it.

=IF(AND(C1>A1,C1<B1),"YA")

 

[JackDanIce]

Welcome to the board.
Try:

=IF(AND(A1<22),B1>22),"YA","Not within defined range")

 

[lprabhu1107]

Hello experts,

The above solution tests only one range i.e.a1 nd b1. I need the value to check the entire ranges in column a and column b and give the appropriate definitions in column c as the result.