Values within a given range

4

I want to make the following formula but I can not. I do not know if it is with =SE() , but what I need to know is whether a value is within a range (1 to 2) or not.

=SE(A1<=B1>=C1;1;0)

If cell A1 is less than or equal to cell B1 and greater than or equal to cell C1 then it should give 1, if not, it should give 0.

This formula gives error, how do I do it right?

    
asked by anonymous 18.08.2015 / 16:50

1 answer

5

It is not possible to combine two comparison operators in the test of a condition, to do this it is necessary to use the function E() .

=SE(E(A1<=B1;B1>=C1);1;0)
    
18.08.2015 / 16:53