Formula - If Then - Contains Text - Change Fomula in another Column

Question

I am trying to apply a change to the "Use Tax Base" Column.

I want to create a formula stating that if the Balance Column contains "ADJ" then I want to change the value in the Use Tax Base column to a negative amount.  I have tried multiple variations in the formula as this is a reversal in our Use Tax.

apathetichell · Accepted Answer

formula tool - Use Tax Base is your column

if contains([Balance],"ADJ") then -1*[Use Tax Base] else [Use Tax Base] endif