Forum Discussion
Solved
Trying to create an IF Statement in Excel if all answers are Yes the cell turn to "YES"
Trying to create an IF statement in Excel when all answers are YES, Column I turns to "YES" and if there is one answer that is "No" then column I turns to "NO".
That's like
=IF( PRODUCT( (C4:C9="yes")*1) * PRODUCT( (E4:E9="yes")*1) * PRODUCT( (G4:G7="yes")*1) , "yes", "no")If you are on 365 you don't need PRODUCT
I used the following formula which worked much better but still need to include the N/A.
=IF(COUNTIF(C4:C9,"<>YES")+COUNTIF(E4:E9,"<>YES")+COUNTIF(G4:G7,"<>YES"), "NO", "YES")
=IF(COUNTIF(C4:C9,"<>YES")+COUNTIF(E4:E9,"<>YES")+COUNTIF(G4:G7,"<>YES"), "NO", "YES")
Do you mean #N/A error returned by function or text "N/A" ?
- Text "N/A", if someone answers a question with a "N/A" the overall is still a "YES"
Thank you. Does previous formula to check "no" works, or that could be other variants except "yes", "no" and "n/a" ?