 # 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

That works perfectly!! Thank you so much for your help

• 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?

• Re: Formula Query dependent on outputs of others

Thanks, I've tested them and is working the way I need it to