If statement with contains instead of equals

[BillyL14]

Hi 

I was wondering how to do an if statement where instead of saying something like " if x is equal to y then b=a", that you could do something like:

if the value in a column of numeric codes does not contain "2202", then the value for that code in another will be blank?

Have tried several conditional functions but can't seem to get it at the moment.

I have attached a sheet describing what I am trying to do

Thanks

[BradWerner · Accepted solution]

Thanks for the great examples! You can totally do this.

Switch the [Code] field to a string to be able to use CONTAINS. Then write a formula to make [Value] Null if it does not contain certain text. See the attached workflow for an example.

For a result of:

[BillyL14]

@BradWerner , thanks! worked perfectly