Nested if statement or Nested if OR statement
 

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

Nested if statement or Nested if OR statement
 

try
=if(and(or(a2=1,a2=2),or(b2=1,b2=2),or(c2=1,c2=2)) ,"c","nc")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CD27" wrote in message
...
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

Nested if statement or Nested if OR statement
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CD27" wrote in message
...
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

Nested if statement or Nested if OR statement
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
=IF(AND(OR(A2={1,2,3}),OR(B2={1,2,3}),OR(C2={1,2,3 })),"Correct","")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CD27" wrote in message
...
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

Nested if statement or Nested if OR statement
 

One way:

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

--
Biff
Microsoft Excel MVP


"CD27" wrote in message
...
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

Nested if statement or Nested if OR statement
 

A few keystrokes shorter:

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

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
One way:

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

--
Biff
Microsoft Excel MVP


"CD27" wrote in message
...
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

Nested if statement or Nested if OR statement
 

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

Thanks again and take care

Cedric