IF _ AND _ OR

[oldjay]

I give up. I can't get the correct formula

If A1 =1 And A2 OR A3 =2 then A4 =4 otherwise A4 =""

 

[T. Valko]

Try this:

=IF(AND(A1=1,OR(A2=2,A3=2)),4,"")

 

[YESHWANT]

Hi oldjay,
try this one in A4
=if(a1=1,if(a2=2,4,if(a3=2,4,"")),"")

 

[FloMM2]

oldjay,
Another solution:
"=IF(A1=1*AND(A2=2),4,IF(A1=1*AND(A3=2),4,""))"
hth