Forum Discussion
IF / OR statement help
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
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! 🙂
2 Replies
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! 🙂
