Combining functions AND and OR
 

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.

Combining functions AND and OR
 

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.

Combining functions AND and OR
 

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.

Combining functions AND and OR
 

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