How to create an 'if contains' formula

Question

I am trying to write a formula given the following:

first column contains list of identifiers, I have created a second column. I would like the second column to be populated by any identifiers containing the text "LX" in the corresponding rows. If the identifier in column 1 does not contain "LX", the corresponding cell in the second column should remain blank.

Something to the effect of an 'if cell A1 contains "LX", then B1 = A1, if not null'

Claje · Accepted Answer

Hi,

Assuming your columns were named [A] and [B] in that example, here's a formula that should work:

IF CONTAINS([A],'LX') THEN [A] ELSE NULL() ENDIF

You should write this formula on Column B so that it is the one that is updated.

BenMoss · Accepted Answer

IF CONTAINS([fieldA],"LX") THEN [fieldA] ELSE NULL() ENDIF