GeoffreyHarmuth
8 years agoQrew Captain
formula compilation help
I just need some direction on how to compile an if type formula:
I have a questionnaire with a list of approx 20 "Yes" "No" "N/A" options in each (drop down list)
I want to create a quick formula that checks all questions. If any of the questions have the answer "No" it will give me a "Non-compliance" result,
and if they are all yes it will give me a "Compliant" result
not sure if this is done with an if statement or not?
I have a questionnaire with a list of approx 20 "Yes" "No" "N/A" options in each (drop down list)
I want to create a quick formula that checks all questions. If any of the questions have the answer "No" it will give me a "Non-compliance" result,
and if they are all yes it will give me a "Compliant" result
not sure if this is done with an if statement or not?