IF / OR statement help

[DSmith4]

Hello, 

I have a dataset with a list of vendor numbers to exclude. If the vendor number is on the list I will be excluding it, however, one of those vendor numbers I want to include some of the values, but not all.

I am trying to make a statement like this

IF(NOT(ISBLANK('vendor'))) OR IF ('vendor' = "103055" AND ('material' = "Truck")), "include","exclude"

Basically, IF the vendor is blank include the value, BUT also include values if vendor is 103055 and material is truck.

Is this possible?

Thanks

[JarroVGIT · Accepted solution]

You can use && and || operators. Something like this:

Column = IF(NOT(ISBLANK(Table[vendor])) || (Table[vendor] = 103055 && Table[material] = "Truck"), "Include", "Exclude")

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

What are the values you are trying to include? An example of your data would be very useful here!