Using filters for passing multiple criterias

Hi guys,

I have a huge database, and I'm using a lot of switches (filters) to filter rows. I can't figure out a formula for the following filter.
There are two columns: a status (1st, 2nd, 3rd and so on, even zero status which are the rest), and the second column is value. Value is connected to the status column. The higher the value, lower at status.

And I want a drop-down filter in the first row of my big excel database, which I show it in the JPG file.
Here's how it works:

- 1: select every 1st status IF the value is higher than "0"
- 2: select every 2nd status IF the value is higher than "0"
- 3: select every 3rd status IF the value is higher than "0"
- 1+2: select every 1st AND 2nd status AND IF the value is higher than "0". (So if the 1st or 2nd status' value is "0", then it should be "leave", no matter the status was 1st or 2nd)
- 1+3: select every 1st AND 3rd (but NOT 2nd) status AND IF the value is higher than "0". (So if the 1st or 3rd status' value is "0", then it should be "leave", no matter the status was 1st or 3rd)
- 2+3: select every 2nd AND 3rd (but NOT 1st) status AND IF the value is higher than "0". (So if the 2nd or 3rd status' value is "0", then it should be "leave", no matter the status was 2nd or 3rd)
- 1+2+3: select every 1st AND 2nd AND 3rd status AND IF the value is higher than "0". (So if the 1st, 2nd or 3rd status' value is "0", then it should be "leave", no matter the status was 1st, 2nd or 3rd)
- 0: select every other than 1st, 2nd or 3rd AND select 1st, 2nd or 3rd status IF the value is equal to "0". (So: select every other than 1st, 2nd, 3rd (it can be 4th or 0th) PLUS 1st, 2nd, 3rd with 0 values)
- all: select every rows

I hope, I could write down the criterias well and understandable. If it is not clear, please, let me know, and I'll try to write better.

I attached a JPG and an example excel file.

Example JPG: http://www.excelforum.com/attachment.php?attachmentid=490956&stc=1&d=1480195832
Example XLS: http://www.excelforum.com/attachment.php?attachmentid=490957&d=1480195832

I have to admit, I tried to solve this on my own.

This is how so far I got.

=IF(OR($B8=1,$B8=2,$B8=3),IF(OR($D$1="all",ISNUMBER(SEARCH($B8;$D$1))),"PASSED criterias","leave"),IF(OR($D$1="all";AND($D$1=0,OR($B8=0,$B8>3))),"PASSED criterias","leave"))

But it is not treat that if a status number is okay but has zero value.