IF and OR formula

[creative999]

Hi

Need some help with creating a formula for this:

IF A1= 'Shop'
AND
B1='clothes', 'shoes' or 'electrical'
Then C=RETAIL

Else C=OTHER

 

[Fluff]

How about

=IF(AND(A1="shop",OR(B1={"clothes","shoes","electrical"})),"retail","other")

 

[creative999]

=IF(AND(A1="shop",OR(B1={"clothes","shoes","electrical"})),"retail","other")

Perfect - thank you !!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[creative999]

I need to modify the formula a little to include another value (bold below). I have tried this but doesn't work:

=IF(AND(A1={"UNIT","shop"},OR(B1={"clothes","shoes","electrical"})),"retail","other")

Any suggestions?

 

[Fluff]

You need another OR in there like

=IF(AND(or(A1={"UNIT","shop"}),OR(B1={"clothes","shoes","electrical"})),"retail","other")

 

[creative999]

You need another OR in there like

=IF(AND(or(A1={"UNIT","shop"}),OR(B1={"clothes","shoes","electrical"})),"retail","other")

Thank you so much.

 

[Fluff]

You're welcome.