nested And function within IF

[AnnaL]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
WHY to YOU USE 26<=A7 in function below<o></o>
<o> </o>
=IF(AND(AND(26<=A3,A3<=46),B3="M",C3="S"),"yes","no") <o></o>
<o> </o>
THE SAME RESOUTL WITH <o></o>
<o> </o>
=IF(AND(AND(A7<=46,A7>=26),B7="M",C7="S"),"YES","NO")<o></o>
<o> </o>
can someone please explain that for me <o></o>
thank you

 

[rudfaden]

The conditions ae the same in both case. That is, you changed the order but not the condition.

26<=A3: A3 must be lager than or equal to 26

A7>=26 is the same as 26<=A7: must be lager than or equal to 26.

The same is true for the other conditions

 

[AnnaL]

The conditions ae the same in both case. That is, you changed the order but not the condition.

26<=A3: A3 must be lager than or equal to 26

A7>=26 is the same as 26<=A7: must be lager than or equal to 26.

The same is true for the other conditions

Thank you