Multiple if contains elseif troupleshoot
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you looking for [Taxability] to equal "Taxable" or contain the word taxable in the field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked. Thank you! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked. Thank you!
