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?