IF function

[snash]

In a new column I want the result to be "Channel" except for the following criteria:

If column A(District) = Intercompany and
if column C(Product group) <> Chocolate
and column B(Country) = US with
column C(Product group) = Fruit, veg or Minerals

Does this make sense?

 

[gmhumphr]

Your original logic flow is a little unclear to me. I took it to mean either of two conditions (OR statement) may be true to override the default of Channel:

So either:
1. A = Intercompany AND C <> Chocolate
2. B = US AND C = any of {Fruit, Veg, Minerals}

Use the following formula:
=IF(OR(AND(A2="Intercompany",C2<>"Chocolate"),AND(B2="US",ISNUMBER(MATCH(C2,{"Fruit","Veg","Minerals"},0)))),"YOUR CHOICE","Channel")

 

[snash]

thanks a million - glad you were able to dicpher what I couldn't write It works perfectly - Thank you!