Try this:

=IF(AND(OR(C2=X1,C2=X2,C2=X3),OR(C4=Y1,C4=Y2,C4=Y3 )),"Criteria
Matched","Criteria NOT Matched")

Regards,
Paul

"Jan Buckley" wrote in message
...
What is the proper syntax for using AND and OR together in the same
statement? I want to say IF C2=x1 OR c2=x2 OR c2=x3 OR c2=x4, AND c4=y1 OR
c4=y2 OR c4=y3, THEN, ELSE. I can't seem to get it right. Help, please.
Thanks in advance.