If it contains and contains

[mmustkee]

Hi team,

I have a table and I want if my 'state code' column contains 'R' and 'Number' column contain 11 then 'Type column' should be 'in limit' else Out of limit

Number	States Code	Type
11	R
11	R
13	o
14	o
15	o
16	R
17	R
18	C
19	J
11	R
21	C
22	J
23	R
24	C
25	J
26	R
11	C
28	J
11	R
30	C
31	J
11	R
22	C
34	J
11	R
36	C

[Qiu · Accepted solution]

@mmustkee 

A select is needed to change the data type for Number column.

[grazitti_sapna · Accepted solution]

Hi @mmustkee  is this what you are looking for?

I just have one question why is there a need for using contains function when we can specifically mention the number and state code as per the dataset?

Thanks.

[mmustkee]

Hi Sapna,

You are right. NO need to use contains formula. It worked.

Thanks a lot.

Thanks,

Mohammad Mustkeem

[grazitti_sapna]

@mmustkee , you are most welcome and thanks for the mark and like.

[mmustkee]

Thanks Qiu. You are so quick.