Hi, I hope all is well.
I'm trying to understand a few things while also fixing a formula:
1. What's the difference between '=' and '=='
- I'm assuming I used it correctly below
2. How do you end an 'IF Contains" formula
If Contains([Input Rate], "GST")
THEN [Recoverable Tax (Base Currency)]==[Input GST]
3. How do you end an 'IF Contains' statement if you add an "OR" or an "AND"
If Contains([Input Rate], "EXCLUDE")
THEN [Recoverable Tax (Base Currency)]==[Exclude]
OR
If Contains([Output Rate], "EXCLUDE")
THEN [Tax Amount (Base Currency)]==[Exclude]
ELSE ''
ENDIF
Solved! Go to Solution.
To answer your questions in order:
If Contains([Input Rate], "EXCLUDE")
THEN [Recoverable Tax (Base Currency)]==[Exclude]
ElseIf Contains([Output Rate], "EXCLUDE")
THEN [Tax Amount (Base Currency)]==[Exclude]
ELSE ''
ENDIF
It appears that I was being repetitive in my formula:
If Contains([Input Rate], "GST")
THEN [Recoverable Tax (Base Currency)] else "" endif