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

[WICKETT01]

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 solution]

formula tool - Use Tax Base is your column

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

[WICKETT01]

 Thank you.  I have such tunnel vision with my work it's hard to think outside the box sometimes.  Much appreciated.