Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm writing a function like:
IF( = {'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!
Only adding one parenthesys.
If(Match(A, 'apple', 'pear', 'banana'), 'Fruit', 'Others')
Try with Match
If(Match(A, 'apple', 'pear', 'banana'), 'Fruit', 'Others')
Update: Added based on Rubin's response below
Only adding one parenthesys.
If(Match(A, 'apple', 'pear', 'banana'), 'Fruit', 'Others')
Yup