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
