2 Replies Latest reply: Jun 7, 2018 12:43 PM by Sunny Talwar RSS

    IF function

    Wanyun Yang

      I'm writing a function like:

      IF([A] = {'apple','pear','banana'},'Fruit','Others')

      A is a field with values apple, pear, banana, candy, etc.

      But the expression editor shows there is error in expression. The error message is: ')' expected.

       

      Any ideas why? Thanks for help!