multiple if's and or

[excelNewbie22]

how can make e1 to work?
assuming i can add more to the formula later on

test
	A	B	C	D	E
1					if d1=d2 and c1=c2 OR d1=d2 and b1=b2 OR d1=d2 and a1=a2
2	8	1	3	1	0
3	6	2	7	4	0
4	2	1	1	1	1
5	7	4	1	1	0
test

Cell Formulas
Range	Formula
E2:E5	E2	=IF(AND(D2=1,D3=1,C2=1,C3=1),1, 0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E1:E5	Cell Value	=1	text	NO

 

[Fluff]

How about

=IF(D2=D3,IF(OR(C2=C3,B2=B3,A2=A3),1,0),0)

 

[excelNewbie22]

it is good but i was in a rush to ask so i didn't notice i'd forget to write (sorry!)
if d1=d2=1 and c1=c2=1 OR d1=d2=1 and b1=b2=1 OR d1=d2=1 and a1=a2=1
and also need only to check if two pairs equals 1 (like: d1=d2=1 and a1=d2=1)
and the formula will return 1(true) even if there's 3 pairs (d1=d2=1, c1=c2=1,b1=b2=1)

 

[Fluff]

In that case how about like

=IF(AND(D2=1,D3=1),IF(OR(AND(C2=1,C3=1),AND(B2=1,B3=1)),1,0),0)

 

[excelNewbie22]

can a condition add to it? which if there's 3 pair's (including d2=d3=1) the result will be 0 ?
added a2:a3...

=IF(AND(D2=1,D3=1),IF(OR(AND(C2=1,C3=1),AND(B2=1,B3=1),AND(A2=1,A3=1)),1,0),0)

 

[Fluff]

Try

=IF(AND(D2=1,D3=1),IF(--(((AND(C2=1,C3=1))+(AND(B2=1,B3=1))+(AND(A2=1,A3=1)))=1),1,0),0)

 

[excelNewbie22]

perfecto!
thank you again!

 

[Fluff]

You're welcome & thanks for the feedback.