Custom table if list not equal to then "True"

[Anonymous]

Hey guys im trying to convert this snippet of formula from excel to power query

 

"IF(AND(BA1="Application Development",OR(AH1="Execute",AH1="In Progress"),OR(GU1<>"NIS",GV1<>"NIS",GW1<>"NIS",GX1<>"NIS",GY1<>"NIS",GZ1<>"NIS")),"Yes","")"

I do understand it on excel and is trying to convert it into a power query consolidation.

I already had half of the code in custom column but I'm lost on how to implement "not equal to" my code as of now is 

=if [BA1] = ""Application Development" and List.contains({"Execute", "In Progress"}, AH1) and [Red text above into here] then "Yes" else ""

I can do or long way but is there any tricks to lessen the code just like using List.Cointans for Or

[xzmiche · Accepted solution]

Try this:

not List.Contains({[GU1],[GV1],[GW1],[GX1],[GY1],[GZ1]},"NIS")