Conditional formula

[snash]

Hi there,
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 show as Non-channel.


What's the correct logic in writing this in excel formula?

thanks in advance for your help.

 

[Scott T]

This should work

=IF(AND(A2="intercompany",B2="us",OR(C2="fruit",C2="veg")),"Channel","Non-Channel")

 

[Marcílio_Lobão]

snash, Good morning.

Try to use:

=IF(AND(A1="Intercompany",B1="US",OR(C1={"Fruit","Veg"})),"Channel","Non-channel")

Is that what you want?

I hope it helps.

 

[snash]

that's perfect - thank you both!

 

[Marcílio_Lobão]

snash,

Glad to have helped you.

Thanks for the feedback.

 

[snash]

Ok, I'm throwing a little mix in:

Everything will be "Channel" except:

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?

 

[snash]

Hope someone can understand what I'm trying to say

 

[Scott T]

Is this what you want?

=IF(AND(A2="intercompany",B2<>"chocolate",C2="us",OR(D2={"fruit","veg","minerals"})),"not channel","Channel")

 

[snash]

thank you

 

[Scott T]

You are welcome.