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

    How to use if statement with multiple conditions

    Amey Diwanji

      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.