IF CONTAIN A or B or C ( Multiple) Condition

[Anonymous]

Dear Team

Need your help again

Logics table below

Thanks, really appreciates any help

Syaiful Efendi

[danextian · Accepted solution]

Hi @Anonymous ,

Try this 

column =
IF (
    CONTAINSSTRING ( Table[Column], "kg" )
        || CONTAINSSTRING ( Table[Column], "bags" )
        || CONTAINSSTRING ( Table[Column], "kgs" )
        || CONTAINSSTRING ( Table[Column], "pallet" )
        || CONTAINSSTRING ( Table[Column], "packages" )
        || CONTAINSSTRING ( Table[Column], "case" )
        || CONTAINSSTRING ( Table[Column], "cbm" ),
    1,
    0
)

Note: CONTAINSSTRING is not case-sensitive.

[Tahreem24]

@Anonymous ,

You can also follow @danextian  approach. Or try below approach to get your result.

You can also try below approach:

Column = 

if(SEARCH("Kg",Table[Column],1,0),1,

if(SEARCH("Kgs",Table[Column],1,0),1,

if(SEARCH("bags",Table[Column],1,0),1,

if(SEARCH("pallet",Table[Column],1,0),1,

if(SEARCH("package",Table[Column],1,0),1,

if(SEARCH("case",Table[Column],1,0),1,

if(SEARCH("cbm",Table[Column],1,0),1,0))

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Thanks for ur help

[amitchandak]

@Anonymous , seems like a solution from @danextian has worked for you. Can you please mark the solution

[danextian]

Hi @Anonymous ,

If this solves your problem, please accept the post as solution.