How do I use the "or" operator in if statement?

[Ocean Zhang]

I'd like to return a value if either "this" or "that" are present in cell a2. I tried:

if(isnumber(search("this" or "that",a2)),"good",a2)

but it's not working. What am I doing wrong?

[jeffreybrown]

How about something like:

=IF(OR(A2={"This","That"}),"Good","")

[arthurbr]

XL also has a useful HELP which can be accessed with the F1 key

[Ocean Zhang]

thanks jeff and arthur!

Thanks for showing me the {} and the proper formatting. I got this to work:

=IF(OR(ISNUMBER(SEARCH({"This","That"},A2))),"Good",A2)