If formula evaluating a string

[iksotof]

Good afternoon

i am looking for to return one of 3 values depending on another cell value. If the reference cell is populated and contains a certain string, say AB, I would like my target cell to say one thing, eg "hello", if the string doesn't contain AB then I'd like it to say Bye, if the reference has no string or entries in it I'd like my target not to populated. I am struggling a little bit with this. Can anybody please assist?


Many thanks Darren.

[Rudi]

This should do what you need:

=IF(A1="","",IF(A1="AB","Hello","Bye"))

[HansV]

Let's say the reference cell is D5. If you want to return "hello" if D5 equals "AB":

=IF(D5="", "", IF(D5="AB", "hello", "bye"))

If you want the formula to return "hello" if the value of D5 contains "AB", possibly among other text:

=IF(D5="", "", IF(ISNUMBER(SEARCH("AB", D5)), "hello", "bye"))

[iksotof]

Thank you Rudi it's not quite right, I think my explanation wasn't too clear, I mean if my string contains AB, together. Ie 1234AB454545

Thanks

[Rudi]

Ah... I translated, "contains a certain string" incorrectly. Apologies! You could have expressed it as, "a string contains AB".
Hans's second formula will get the job done!