Writing an If statement identifying multiple values

Adam_B

Hello, 

I have an IF statement that I need to identify multiple values in one field and change those Contract types to a different name.  Here is what I have as the formula:

If [Contract Id] = "CW2293919","CW2290258","CW2290427",“CW2291285”,“CW2290240”,“CW2290769”,"CW2291040",“CW2291294”,“CW2291326”,“CW2291328”,“CW2291331”,“CW2291425”,“CW2291954”,“CW2291956”,“CW2292754”,“CW2293279”,“CW2293387”,“CW2293399”,“CW2293404”,“CW2293412”,“CW2293433”,“CW2293741”,“CW2294151”,“CW2294311”,
“CW2297164”
Then [Contract Type] "Supplier Code of Conduct Agreement" ELSE [Contract Type] ENDIF

However, there is something wrong and I can't figure out why. 

Please help

Thanks

Adam 

DataNath

Hey @Adam_B, looks like you also have [Contract Type] left in before your THEN. Try this:

If [Contract Id] IN ("CW2293919","CW2290258","CW2290427",“CW2291285”,“CW2290240”,“CW2290769”,"CW2291040",“CW2291294”,“CW2291326”,“CW2291328”,“CW2291331”,“CW2291425”,“CW2291954”,“CW2291956”,“CW2292754”,“CW2293279”,“CW2293387”,“CW2293399”,“CW2293404”,“CW2293412”,“CW2293433”,“CW2293741”,“CW2294151”,“CW2294311”,
“CW2297164”)
THEN "Supplier Code of Conduct Agreement"
ELSE [Contract Type] ENDIF