In the sheet below, I am using the IF function to determine whether the number in Column C (Variable) falls between the two numbers mentioned in Column A and Column B.
I have entered the formula in Column D that displays the result while Column E shows the formula that I have used.
Excel Question.PNG
If I use the 'less than' symbol (<) in the IF function - A2<C2<B2 - I get the result as False
If I use the 'greater than' symbol (>) in the IF function - B3>C3>A3 - I get the result as True
If my basic math concepts are clear, A2<C2<B2 and B2>C2>A2 are exactly the same and they should give me the same result.
Note: I can solve this by using IF(AND or by including multiple IF conditions, I am just curious to know why excel processes these two conditions differently.
Please ignore the Image attached below. Not sure why it is showing up even after I removed the attachment.
Bookmarks