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
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
Thank you Sergei...this worked fantastic.
HighFiveEm , you are welcome
So I want to update it also if "Yes" or "N/A" then it is Yes. But if "No" in any question then it returns a "NO".