If function question

Question

What is the formula if a number is bigger than the lower range number and yet smaller than the 2nd number being compared.

e.g. My chosen number in column A row 1 $100. The two numbers I wish to fit within to confirm whether true or false is $Column B row 1 is 50 and column C row 1 is $200. I wrote an if statement that read, =if(B1<A1<C2,1,0).

I was looking for a 1 in the cell since A1 is bigger than B1 and less than C2, but I got a Zero 0 answer. As such, how do I correct this formula?

oliverscheurich · Answer

Michael_Hurwich_0418&nbsp;=IF(AND(A1&gt;B1,A1&lt;C1),1,0)You can try this formula.&nbsp;

michael_hurwich_0418 · Answer

Thank you.Will give it a try,

Forum Discussion

If function question

Share

Resources