Malformed If Statement, combining multiple if statements

Question

hi,

I am getting malformed if statement on the below:

If [FOLDER] = "Test1" OR [FOLDER] = "Test2" THEN
if Contains([n_Value],"read")
or Contains([n_value],"inquiry")
or Contains([n_value],"view")
or Contains([n_value],"no access")
or Contains([n_value],"report")
then "Yes"
else "No"
OR
If [FOLDER] = "Test3"
THEN
if Contains([n_Value],"EXEC")
or Contains([n_Value],"WRITE")
then "No"
else "Yes"
endif

How can I fix this?

chuckleswk · Accepted Answer

You can use the following If formula to get the results you want

@wonka1234  Edit: I miss-spoke when I was talking about the nested IF Statements and after careful review and looking at @dYoast's answer, you are missing an ENDIF after that 2nd grouping of IF statements and you need to use an ELSEIF instead of that last OR.