Calculated column with multiple text criteria

[langkio]

Hello All, 

I am trying to create a new calculated column base on multiple text criteria conditions. 

The critieria is if Product Type is not A or B and starts with Description: "xyz", "qss,si", "prc", "aj,prc" assign the numeric value 1 otherwise assign 0.   

The result should be: 

Product Type	Description	New calculated Column
A	HDMI	0
B	sirte	0
C	PD	0
D	HD	0
E	qss,si	1
F	aj,prc	1
G	xyz	1

How would this be written? Thanks. 

[Anonymous · Accepted solution]

@langkio,

There you go: 

New Calculated Column = 
IF (
    NOT ( Table[Product Type] IN { "A", "B" } )
        && (
            LEFT ( Table[Description], 3 ) = "xyz"
                || LEFT ( Table[Description], 6 ) = "qss,si"
                || LEFT ( Table[Description], 3 ) = "prc"
                || LEFT ( Table[Description], 6 ) = "aj,prc"
        ),
    1,
    0
)

[langkio]

Thanks!!