Nested if statement or Nested if OR statement

[CD27]

Hello,
Trying to figure out how to do the below...I have 3 columns and in
column D i need to be able to input a text.

So, If cell A2 has a 1 or 2 AND cell B2 has a 1 or 2 AND cell C2 has
a 1 or 2 input "Correct" in cell D2.


A B C D
1 1 2
1 2 2


I can not get this correct. Any help would be appreciated.

Thanks
CD

 

[Don Guillett]

try
=if(and(or(a2=1,a2=2),or(b2=1,b2=2),or(c2=1,c2=2)),"c","nc")

 

[Niek Otten]

=IF(AND(OR(A2={1,2,3}),OR(B2={1,2,3}),OR(C2={1,2,3})),"Correct","")

 

[Niek Otten]

Sorry, I read 1, 2 or 3.
Adjust accordingly or use Don's formula

 

[T. Valko]

One way:

=IF(AND(OR(A2={1,2}),OR(B2={1,2}),OR(C2={1,2})),"Correct","")

 

[T. Valko]

A few keystrokes shorter:

=IF(SUM(COUNTIF(A2:C2,{1,2}))=3,"Correct","")

 

[CD27]

Thanks Niek, Don and T. Valko,
It works like a charm now.

Thanks again and take care

Cedric