make an if statement on part of text

[Anonymous]

Hi,

I'm trying to make a collum where te values are based on a part of tekst from a other collums values.

The values should be a "S" when the texk NVTZ is found in the name, otherwise it should be an "J"

I'd tried the following:

Collum = IF(SEARCH("NVTZ";DimOplossing[Naam]); 'S', 'J'))

The text in the collums lokks as below.

[Anonymous · Accepted solution]

Found it:

Collum = IF(ISERROR(SEARCH("NVTZ";DimOplossing[Naam]));"S";"J")