Combining IF(OR & IF(AND Statements

[Stealth2016]

I have the following statements that ascertain whether a 1 or 0 is shown in a destination cell. I have been trying to combine both statements with no luck.

=IF(OR(T29="W"),1,ROUNDDOWN(COUNTIF(T29:T33,"W")/2,0))

=IF(AND(T29="W"),ROUNDDOWN(COUNTIF(AR29:AR33,"W"=2),0))

Is it possible to combine them or do I have to come up with a different formula altogether.

 

[AlanY]

could you state the condition cell the show 0 & 1 please

 

[Stealth2016]

The cell the 0 & 1 goes in is a blank cell AX67

 

[AlanY]

when i meant was

if T29 = "W" and what condition required to assign 0 or 1 to AX67?

 

[Stealth2016]

If T29="W" it will put a 1 in AX67 but if AR29:AR33,"W"=2 then I want a 0 in AX67 but if T29="W" or T29:T33,"W"=2 then I want a 1 in AX67

 

[Stealth2016]

What I am after is IF T29="W" or T29:T33,"W"=2 a 1 will be in AX67 but if both T29="W" and AR29:AR33,"W"=2 I want 0 in AX67

 

[AlanY]

may be

Book1
	T	AR
29	W	W
30
31	W
32
33
34
66
67	1
Sheet1

Cell Formulas
Range	Formula
T67	=IF(T29="W",IF(COUNTIF(T29:T33,"W")=2,1,IF(COUNTIF(AR29:AR33,"W")=2,0,"")),"")

Book1
	T	AR
29	W	W
30
31
32		W
33
34
66
67	0
Sheet1

Cell Formulas
Range	Formula
T67	=IF(T29="W",IF(COUNTIF(T29:T33,"W")=2,1,IF(COUNTIF(AR29:AR33,"W")=2,0,"")),"")

note that when both conditions met it will yield 1.

Book1
	T	AR
29	W	W
30
31
32		W
33	W
34
66
67	1
Sheet1

Cell Formulas
Range	Formula
T67	=IF(T29="W",IF(COUNTIF(T29:T33,"W")=2,1,IF(COUNTIF(AR29:AR33,"W")=2,0,"")),"")

and only work with "W" = 2, not greater.

Book1
	T	AR
29	W	W
30
31
32	W
33	W
34
66
67
Sheet1

Cell Formulas
Range	Formula
T67	=IF(T29="W",IF(COUNTIF(T29:T33,"W")=2,1,IF(COUNTIF(AR29:AR33,"W")=2,0,"")),"")

 

[Stealth2016]

Thanks AlanY. This is not quite what I need. I need a 1 in AX67 if T29="W" even if it is the only cell with a "W"in it unless AR29:AR33,"W"=2 and a 1 in AX67 if T29:T33,"W"=2.

 

[AlanY]

ok, try this

=IF(COUNTIF(AR29:AR33,"W")=2,0,if(or(T29="W",COUNTIF(T29:T33,"W")=2),1,""))

 

[Stealth2016]

Brilliant, that solves the problem. Thank you for your assistance.