If Contains Formula

[SH_94]

Dear Community,

May i know how to write the complete formula for the following :

1.If contain A, then give me " A "

2. If contain B, then give me  "B"

3. If contain other than A and B , then give me " others"

I know how to write for the step 1 and 2 as follow but not sure how to write the step 3.

IF Contains ([production_companies], "A") THEN "A"
ELSEIF Contains([production_companies], "B") THEN "B"

Many thanks in advance

[atcodedog05 · Accepted solution]

Hi @SH_94 

Complete it like 

IF Contains ([production_companies], "A") THEN "A"
ELSEIF Contains([production_companies], "B") THEN "B"

ELSE "Others" Endif

Hope this helps : )