Contains not working as expected

Question

Hi everyone,

I am having trouble making the following formula work properly.

IF Contains("APT", [Atribute]) then "APT" else Null() ENDIF

It works fine when [Atribute] contains "APT" by itself, but it does not work with cases such as "APT-AAA".

I want to ifentify any cell that contains "APT" ¿Am I not using the correct function?

Any help is appreciated.

JosephSerpis · Accepted Answer

Hi @daniel_rdz can you try this syntax IF Contains([Atribute], "APT") then "APT" else Null() ENDIF?