If condition with multiple THENs / if condition with 'show all except one' in then

[padmanabhv]

Hello,
Lets say I have data in 4 columns, user and value1, value2, value3
each user could have value 0,1 or 2 for each of the values.

If a person selects 'value2'
I need a function to apply that would then show me all data where value2 is equal to 1 or 2 (basically non-zero)

I can make it work to only show 1 or 2 using 
= if (GetFieldSelections([$Field]) LIKE '*value2*',1,'ALL')
or 
= if (GetFieldSelections([$Field]) LIKE '*value2*',2,'ALL')

But how do I make it work if I want it to show all non zero values, be it 1 or 2
= if (GetFieldSelections([$Field]) LIKE '*value2*',(WHAT DO I PUT HERE? ),'ALL')

Appreciate any help! Thank you !

[padmanabhv · Accepted solution]

To answer my own question,
instead of using 'Select values in field'

I used 'Select values Matching Search Criteria' 
and
= if (GetFieldSelections([$Field]) LIKE '*value2*','>0','ALL')

And got it to work !