IF OR/AND Statement with multiple conditions

[Des_cool]

I am stuck on this IF AND statement that adds additional conditions. I am able to find one condition but I am trying to add on to it when other conditions are met within the same cell.
e.g.
IF(AND(B2="TEST",C2="one"),"Good","")
this above statement worked to fine this condition but how do I add additional conditions within C2 e.g. if B2="TEST", C2 ="two" or C2="three" or C2="four". I would like to capture all these conditions and mark as "Good"?

What is the best way to write this function? I tried IF OR/AND statements that didn't work. Thanks in advance for your assistance!

 

[jasonb75]

How about

=IF(AND(B2="TEST",OR(C2={"one","two","three","four"})),"Good","")

 

[Sufiyan97]

Try

=IF(AND(B2="TEST",OR(C2="one",C2="two",C2="three",C2="four")),"Good","")

 

[Des_cool]

How about

=IF(AND(B2="TEST",OR(C2={"one","two","three","four"})),"Good","")

Thank you, that worked!! Appreciate your time.

 

[Des_cool]

Try

=IF(AND(B2="TEST",OR(C2="one",C2="two",C2="three",C2="four")),"Good","")

 

[Des_cool]

Thanks a lot, appreciate your time!

 

[Sufiyan97]

You're welcome & thanks for follow-up.