Replace multiple IFs statement by IF list contains

[#1]

In a calculated dimension for a pivot table, I would like to test the condition

IF(MyField in ['A','B','C','D'])

For now, I am doing

IF(MyField = 'A' OR MyField = 'B' OR MyField = 'C' OR MyField = 'D', ..., ...)

Since expression for MyField is heavy, I would like to replace this by a more efficient syntax, such as search in a list (like a contains() method in other languages). Is there such a syntax?

Thanks in advance!

[its_anandrjs]

You can try match function also

Ex:-

=IF( Match( MyField,'A','B','C','D' ))

[#3]

is =IF( Match( MyField,'A','B','C','D' ),...,...) strictly equivalent to IF(MyField = 'A' OR MyField = 'B' OR MyField = 'C' OR MyField = 'D', ..., ...) ?

[its_anandrjs · Accepted solution]

Yes you are right or may be you can use Index() function for this.