Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Strange check the Test App
you can use match function for this
match(VAR, 1,2,3,4,5).. and so on..
hope it helps!!!
I try this
=IF(MATCH(VAR,1,2,3,4,5,6),'A','B')
but it does not works...
Strange check the Test App
Ok, now it work!
Thanks