IF function with multiple values

[#1]

Hi

I have to write an IF condition like

=IF( (VAR=1 OR VAR=2 OR VAR=3 OR VAR=4 OR VAR=5 OR VAR=6) AND ( FOO=2 OR  FOO=3 OR  FOO=4 OR  FOO=5 OR  FOO=6),'A','B')

It works, but exist a quick way to write it? Something like

= IF( (VAR in (1,2,3,4,5,6)) AND (FOO in (2,3,4,5,6),'A','B')

Thanks

[rajni_batra]

you can use match function for this

match(VAR, 1,2,3,4,5).. and so on..

hope it helps!!!

[#3]

I try this

=IF(MATCH(VAR,1,2,3,4,5,6),'A','B')

but it does not works...

[rajni_batra · Accepted solution]

Strange check the Test App

[#5]

Ok, now it work!

Thanks