New Column with IF Formula

[roxannshepard]

I am trying to add a column with an IFS formula. 

Column F: "POST"

Column J: "AMOUNT"

If POST text contains "DR", then calculate AMOUNT to be a negative number

If POST text contains "CR", then leave AMOUNT as a postive.

Please help. Thank you in advance. 

[andhiii079845]

Perhaps like: 

mycolumn = if(CONTAINSSTRING(ColumnF)="DR",-ColumnJ,if(CONTAINSSTRING(ColumnF)="CR",ColumnJ,<if not CR or DR,do>)