Forum Discussion
Solved
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 v...
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! 🙂
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! 🙂