Give this a whirl...

=if(and(or(C2=x1, c2=x2, c2=x3, c2=x4), 0r(c4=y1,
c4=y2, c4=y3)), "Then", "Else")

--
HTH...

Jim Thomlinson


"Jan Buckley" wrote:

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.