I want a column to return the values either Channel or Non-channel based on the following criteria but having trouble with the exact formula:
If column A(District) = Intercompany and
If column B(country) = US and
if column C(Product group) = Fruit or Veg
then Show as Channel or else...