Forum Discussion
Solved
IF function
Hi,
I´m trying to write a simple formula along the lines of: IF((1<2<3), "ok", "x")
Why does excel return x and how do I rewrite it, so the excel returns ok?
Thanks 🙂
=IF(AND(1<A1,A1<3), "ok", "x")
Does this return the intended result? Basically you have to reference the cell that you want to evaluate.
4 Replies
=IF(AND(1<A1,A1<3), "ok", "x")
Does this return the intended result? Basically you have to reference the cell that you want to evaluate.
- Thank you! This works perfectly 🙂
(I didn´t realise, that AND is necessary in this case)- FYI, just so you understand, when you write 1<2<3 excel will interpret that as a single equation piece by piece and after the 'first step' will have either TRUE<3 which results in FALSE. That said if you try 3>2>1 then you have TRUE>1 and the result is TRUE. Basically excel considers T/F values > any numeric value. For example, 3<2>99999999 results in TRUE because 3<2 is FALSE and FALSE>9999999 evaluates to TRUE.
I'm a strong believer that it is very important to understand HOW your tool works.
