Forum Discussion
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...
Perhaps like:
mycolumn = if(CONTAINSSTRING(ColumnF)="DR",-ColumnJ,if(CONTAINSSTRING(ColumnF)="CR",ColumnJ,<if not CR or DR,do>)