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?