Forum Discussion

Copper Contributor

Jun 21, 2021

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".

excel

Formulas and Functions

SergeiBaklan

Jun 21, 2021

HighFiveEm

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

SergeiBaklan

Diamond Contributor

Jun 21, 2021

HighFiveEm

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

MindyS
Copper Contributor
Mar 24, 2022
If i have two columns, and i type yes or no in the boxes how can i create a formula that if both columns in a row is no the answer will be no? but if one answer is yes and 1 is no the answer should be yes?
- SergeiBaklan
  Diamond Contributor
  Mar 24, 2022
  MindyS
  
  Depends on how your data is structured, as variant that could be
HighFiveEm
Copper Contributor
Jun 21, 2021
Thank you Sergei...this worked fantastic.
- SergeiBaklan
  Diamond Contributor
  Jun 22, 2021
  HighFiveEm , you are welcome
  - HighFiveEm
    Copper Contributor
    Jul 12, 2021
    SergeiBaklan
    
    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".