Multiple if contains elseif troupleshoot

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

Help

Accepted answers

JosephSerpis

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

All comments

JosephSerpis

Hi @thummasantosh you need to use this syntax.

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335