Conditional replacement of text

[louyang]

Hi there,

I'm trying to replace text in Column C, if Column A and Column B met the conditions, if don't meet the condition, then Column C stays the same, so my formula is as below but not working:

if contains([Column A],'xx' and [Column B],'yyy')
THEN Replace([Column C], 'aaaa cost', 'bbbb cost')
ELSE ([Column C])
ENDIF

Could someone please let me know what was wrong I got here?

The formula turns to black colour, when I typed ELSE part.

Thank you.

Lindsay

[geraldo · Accepted solution]

@louyang

Formula:}
}

if contains([Column A],'xx') and contains([Column B],'yyy')
THEN Replace([Column C], 'aaaa cost', 'bbbb cost')
ELSE ([Column C])
ENDIF

[louyang]

Thank you so much geraldo, it works!