Conditional Column based on 2 columns

[davehus]

Hi,

I want to create a conditional column based on 2 columns. I can use AND OR fine, however is there an inlist equivalent? 

Example if [C1] = 201 And [C2] InList (105,106) then [Value1] Else [Value2].

Any help would be appreciated. 🙂 

[sjc4062 · Accepted solution]

Something like 

=if(c1 = 201 && c2 in {105,106), [Value1],[Value2])

That should work

[davehus]

Thank you very much.. Struggled with the logic for a while. This makes more sense 😁