IF formula if a cell contains specific letter

[janema]

I am struggling with this formula to return a specific value if the cell contains the letter "s"

 

[Joe4]

Looks like it is working correctly to me.

Your formula reads:
If F4 = "S", then return "Sales Plan", otherwise return "STI".
Since F4 = "Band 4 Target 15%", your formula is correctly returning "STI".

 

[janema]

Looks like it is working correctly to me.

Your formula reads:
If F4 = "S", then return "Sales Plan", otherwise return "STI".
Since F4 = "Band 4 Target 15%", your formula is correctly returning "STI".

Right, but I need it to return "Sales Plan" if there is a "S" in the source. Example: "Band 3S Target 10%" should return "Sales Plan" but it is also returning "STI"
My formula isn't working

 

[Joe4]

Right, but I need it to return "Sales Plan" if there is a "S" in the source. Example: "Band 3S Target 10%" should return "Sales Plan" but it is also returning "STI"
My formula isn't working

OK, you didn't show any in your example that contain the letter "S". Your formula only looks for it to be EXACTLY equal to "S".
If you want to check for the letter, try:

=IF(ISNUMBER(FIND("S",F4)),"Sales Plan","STI")

Note that FIND is Case Sensitive (only looking for capital "S").
If you want to search for either "S" or "s", the change the word "FIND" in that formula to "SEARCH".

 

[janema]

OK, you didn't show any in your example that contain the letter "S". Your formula only looks for it to be EXACTLY equal to "S".
If you want to check for the letter, try:

=IF(ISNUMBER(FIND("S",F4)),"Sales Plan","STI")

Note that FIND is Case Sensitive (only looking for capital "S").
If you want to search for either "S" or "s", the change the word "FIND" in that formula to "SEARCH".

That worked perfectly! Thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!