using multiple criteria in an If-then statement

[mark gardner]

I am worlking with an If-Then statement. If I want the statement to check on multiple critera (ex: =if(a1=4 and a2>5 and a3<7,"true","false"...how do I write it so it checks on all three criteria before declating the statement true?

thank you

 

[VoG]

Try

=if(and(a1=4,a2>5,a3<7),"true","false")

 

[mark gardner]

thank you