=IF(AND(OR(C2=x1,c2=x2,c2=x3,c2=x4),OR(c4=y1,c4=y2 ,c4=y3)),"Then
condition","Else condition")
--
David Biddulph

"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.