Multiple if contains elseif troupleshoot

[thummasantosh]

Hi,

Can someone help me with if contains formula for the below?

IF Contains([REGION],"EU" AND [TAXABILITY],"Taxable") THEN "DE AP EU RC" ELSEIF Contains([REGION],"NONEU" AND [Taxability],"Taxable") THEN "DE AP NON EU RC" ELSEIF Contains([REGION],"NONEU" AND [TAXABILITY],"Taxable") THEN "EU EXEMPT RC" ELSE "NON EU EXEMPT RC" ENDIF

REGION	TAXABILITY	TAX CODE (RESULT)
EU	TAXABLE	DE AP EU RC
NONEU	TAXABLE	DE AP NON EU RC
EU	NON TAXABLE	EU EXEMPT RC
NONEU	NON TAXABLE	NON EU EXEMPT RC

[JosephSerpis · Accepted solution]

Hi @thummasantosh you need to use this syntax.

IF [REGION]="EU" AND [TAXABILITY] = "Taxable" THEN "DE AP EU RC" ELSEIF [REGION]="NONEU" AND [Taxability]= "Taxable" THEN "DE AP NON EU RC" ELSEIF [REGION]="EU" AND [TAXABILITY]="Non Taxable" THEN "EU EXEMPT RC" ELSE "NON EU EXEMPT RC" ENDIF

[smoskowitz]

Are you looking for [Taxability] to equal "Taxable" or contain the word taxable in the field?

[thummasantosh]

It worked. Thank you! 🙂

[thummasantosh]

It worked. Thank you!