Multiple If Statment help

[wonka1234]

Say I have this dataset - 

Type	Test Conclusion	One Conclusion	Two Conclusion
Detailed	Ineffective	Ineffective	Ineffective
Overall	Ineffective	Ineffective	Ineffective
Detailed	Effective	Effective	Effective
Overall	Effective	Effective	Effective

If Type is detailed then compare test and one, if type is overall then compare test conclusion to two conclusion

This is what I have -

If( [Type] = "Detailed" then [Test Conclusion] = [ One Conclusion] then "Match"
elseif [Type] = "Overall", [Test Conclusion] = [ Two Conclusion] then "Match"
else "Unmatched"
Endif

Thanls.

[alexnajm · Accepted solution]

I think this fixes it! It at least runs, just not sure if it accomplishes your goal - if you need help, please provide your expected output.

If [Type] = "Detailed" AND [Test Conclusion] = [ One Conclusion] then "Match"
elseif [Type] = "Overall" AND [Test Conclusion] = [ Two Conclusion] then "Match"
else "Unmatched"
Endif

[Raj]

Just replace 'then' after "Detailed" with 'And' and this will work

If [Type] = "Detailed" AND [Test Conclusion] = [ One Conclusion] then "Match" elseif [Type] = "Overall" AND [Test Conclusion] = [ Two Conclusion] then "Match" else "Unmatched" Endif

[Qiu]

@wonka1234 
I think @Raj and @alexnajm are giving the correct formula.
I have changed your input a bit so we can observe if the formula is working or not.