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.

  • Re: Formula Query dependent on outputs of others


    You may need to check the order these are evaluated... What if the answers are 'Yes', 'No' and blank? Is the result of that to be M3 or False?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!