Formula Query dependent on outputs of others

  • Hi
    I have 3 Questions A44,A45,A46 with Yes/No answer options in C44,C45,C46
    I am trying to populate a formula in A47 that will show text from M2 if the answers are all No, Show text from M3 if any one of them is Yes, and show False if any one of them is unanswered.
    Im going around in circles!!


    example of what I tried
    M7=IF(AND(C44,C45,C46=""),"NA",IF(AND(C44,C45,C46="No"),"No",IF(OR(C44,C45,C46="Yes"),"Yes")))
    =IF(M7="Yes",M3,IF(M7="No",M2))


    Anyone know of a simple way to do this?

  • Re: Formula Query dependent on outputs of others


    Your basic problem is the ...AND(C44,C45,C46=""). These all have to be explicit comparisons. The following seems to do what you want


    =IF(AND(C4="No",C5="No",C6="No"),M2,IF(OR(C4="Yes",C5="Yes",C6="Yes"),M3,IF(OR(C4="",C5="",C6=""),FALSE,"No Match")))


    I added in a 'No Match' at the end to cover anything not already covered in the comparisons just to illustrate. You might want to replace that with blank or something else.