IF statement with 2 variables

Question

Can someone assist.&nbsp;If 2&lt;3 and 1&gt;2, true = 2 false = 0&nbsp; How do I write this IF statement ?

cbarroso · Answer

Something like:IF(AND(2 &lt; 3; 1 &gt; 2); 2; 0)

kmcdermott1974 · Answer

I have tried and its not working=IF(AND(E36 &lt; E41; E38 &gt; E36); E36; 0)

cbarroso · Answer

I guess the formula is working but the resul is not what you expect 🙂Can u provide a sample of data with the expected result?

cbarroso · Answer

A	B	C	RESULT (IF(AND(B2&gt;A2;B2&lt;C2);B2;0))
1	2	3	2

kmcdermott1974 · Answer

cbarroso&nbsp;E36=$400E38=$2240E41= $2410&nbsp;E43=formula&nbsp;so IF E36&lt;E41 and E38&gt;E36 YES then E43 = E36 NO then E43=0400&lt;2410 YES and 2240&gt;400 YES then E43=$400&nbsp;Further to this IF E36&lt;E41 and E38&lt;E36 YES then E43=E36 NO then E43=0

Forum Discussion

IF statement with 2 variables

9 Replies

Resources