2 Replies Latest reply: Oct 26, 2018 5:44 AM by Amey Diwanji RSS

    How to use if statement with multiple conditions

    Amey Diwanji


      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.