Validating the availability of a number(A1) in a range (B1:C1)

[raghuram117]

Let us suppose the data is in the following sequence. In column D i want to know if the value of A is a number between B & C.


A; B; C; D;

23899011; 23899010; 23899020; Does A in the range of B:C;

 

[Hui]

D1: =If(And(A1>B1,A1<C1),"True", "False")

and copy down

 

[kchiba]

D1: =(A1>B1)+(A1<C1), if the answer is 2 then the number in A is between the number in B and C.

 

[lavkeshbhatia]

D1=(A1>B1)*(A1<C1) returns 1 only if both are true