If(Field1 = A OR Field1 = B OR Field1 = C OR Field1 = D OR Field1 =..... , )

[#1]

Is there an easier way of writing this?

If(Field1 = A OR Field1 = B OR Field1 = C OR Field1 = D OR Field1 =..... , )

I'd like to be able to write something like If(Field1 IN(A, B, C, D, E, F.....) , ).  I have a lot of acceptable values for Field1, and the actual field name and values are much longer strings

Thanks

[MayilVahanan · Accepted solution]

HI

Try like this

=If(Match(Field1,'A','B','C','D'),1, 0)

Hope it helps

[#3]

Maaaaatch, that's the function!  Thank you!