Forum Discussion
Solved
EXCEL IF function with multiple AND/OR conditions
Hello, I am trying to complete an IF function with multiple conditions but cannot seem to figure it out. Any help would be much appreciated. The conditions I am trying to satisfy are, IF: ...
If you meant: exactly two out of the three:
=IF(AND(A1="yes",COUNTIF(B1:D1,"yes")=2),"yes","no")
If you meant: at least two out of the three:
=IF(AND(A1="yes",COUNTIF(B1:D1,"yes")>=2),"yes","no")
If you meant: exactly two out of the three:
=IF(AND(A1="yes",COUNTIF(B1:D1,"yes")=2),"yes","no")
If you meant: at least two out of the three:
=IF(AND(A1="yes",COUNTIF(B1:D1,"yes")>=2),"yes","no")
- That worked. Thank you.
