I’m looking to use a Conditional form from an excel file, which follows the following logic:
IF Taxable Salary > 30000 AND Taxable Salary < 150000 => (Taxable Salary - 30000)* 0.13
IF Taxable Salary > 150000 => (Taxable Salary - 150000)* 0.23 + 15600
TRUE => 0
However, the Rule Engine does not allow me to enter a formula after the condition (so far from what I’ve seen it allows only columns, numbers of strings).
Is there any way around this? What would you guys recommend in this case! Help would be greatly appreciated!