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 |
Solved! Go to 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
Are you looking for [Taxability] to equal "Taxable" or contain the word taxable in the field?
It worked. Thank you! 🙂
It worked. Thank you!