Stealth2016
New Member
- Joined
- Oct 26, 2016
- Messages
- 34
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.
Is it possible to combine them or do I have to come up with a different formula altogether.
Code:
=IF(OR(T29="W"),1,ROUNDDOWN(COUNTIF(T29:T33,"W")/2,0))
Code:
=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.