Two If Not Conditions in Power Query

[LtCmdrData]

In Power Query I am trying to check two different zip code columns for certain conditions. I want to check each column to see if they contain one of four zip codes. If either column contains any of the four zip codes, then I want one result but if neither column contains any of the four, I want a different result returned. Here is a sample of the M code I tried:

if [Origin Zip] <> "37167" or [Origin Zip] <> "43228" or [Origin Zip] <> "76118" or [Origin Zip] <> "92518"
and [Dest Zip] <> "37167" or [Dest Zip] <> "43228" or [Dest Zip] <> "76118" or [Dest Zip] <> "92518"
then "DS"

else "RS"

Perhaps I need to go about this a different way but I am stuck, probably because of the two negative conditions. Can anyone please help? Thank you in advance.

 

[RoryA]

That's why I switched the RS and DS around. If either column matches one of those items, you'll get RS, otherwise you get DS. Is that not what you wanted?

 

[LtCmdrData]

I noticed you switched the RS and DS around, but I didn't realize that was intentional. So, I put in the code just the way you have it, and it is working the way I want it to work. Thank you so much for the help and patience.

 

[RoryA]

Glad we could help (@GraH did most of the work to be fair )

 

[GraH]

Glad we could help (@GraH did most of the work to be fair )

And you actually understood the query. That's what the community is about. Team working.