Forum Discussion

roxannshepard's avatar
roxannshepard
New Member
3 years ago

New Column with IF Formula

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. 

Need Help

1 Reply

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    Perhaps like: 

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