IF function

[wanyunyang]

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!

[sunny_talwar]

Try with Match

If(Match(A, 'apple', 'pear', 'banana'), 'Fruit', 'Others')

Update: Added based on Rubin's response below

[rubenmarin · Accepted solution]

Only adding one parenthesys.

If(Match(A, 'apple', 'pear', 'banana'), 'Fruit', 'Others')

[sunny_talwar]

Yup