Multiple if calculation

[Hammers211]

I have a survey that consists of 7 Yes/No/NA select_one questions. I would like to write a calculation that will evaluate those 7 questions, and if any of them are answered with a "Yes," a note is displayed with the text "Fail."

Here is what I have for my note calculation:

 if(${Prohibited_List} = "Yes", 'Fail', 'Pass') or if(${Drug_Ingredients} = "Yes", 'Fail', 'Pass')

It does not return an error, but it does not function as I would like. I realize I will need to include all 7 questions, but first I'd like to get it working with just these first two.

Thank you!

[ZacharySutherby · Accepted solution]

Hello @Hammers211, 

You can consolidate the condition into one if() statement, for example if(${Prohibited_List} = "Yes" or ${Drug_Ingredients} = "Yes", 'Fail', 'Pass'). 

[DougBrowning]

When you use or no need for two ifs

if(${Prohibited_List} = "Yes" or ${Drug_Ingredients} = "Yes", 'Fail', 'Pass')