How to use if statement with multiple conditions

[ameydiwanji]

Hi,

I am creating a calculated field and using the below if statement to create additional column in my file with new value based on pre-existing value in other column

If(match([New ARN Code]='ARN-9760' OR 'ARN-41778'),'CBC'),'0'

when i am using single condition the function is working, but as i added one more condition to it, there is error:

Missing right parenthesis.

[swuehl]

The match should look like

Match(FIELD, 'Value1','Value2','Value3','ValueN')

and will return 0 when no match is found or the index of the listed values (first match).

[ameydiwanji]

Hey Stefan,

Thanks for the solution. It worked