Returning Values based on text

[Tsch]

Good afternoon
I am looking for help with a formula that would return values based on a cell having a text string for example.
Cell A2 would contain any of the following texts:
Stripe Silver, Matte Silver, Silver/NI, Tin Silver

I would like a formula for cell A1 that would look at cell A2 and if the word silver appears return value Update Price and if silver does not appear return value NA

Cell A1 is currently conditional formatted to look for Update Price and bold, format letters to red as well as to return value update price for any cell having a value of 0 or less.

Thanks

 

[VoG]

Try

=IF(ISNUMBER(FIND("Silver",A2)),"Update price",NA())

 

[GDH]

Try in cell A1

=IF(SEARCH("silver", B2)=1, "Update price","N/A" )

 

[Desu Nota from Columbus]

=IF(ISNUMBER(SEARCH("Silver",A2)),"Update Price","NA")

 

[GDH]

Sorry...

My intial attempt assumes that silver will be at the beginning of the word.
Using the search as opposed to find might be better as search is not case sensitive.

=IF(ISNUMBER(SEARCH("silver", B2)), "Update price","N/A" )

 

[Desu Nota from Columbus]

Note that the difference between FIND and SEARCH is that the find function is case sensitive (Silver <> silver) whereas the search function (Silver = silver).

Just food for thought in case silver may not always exist capitalized/uncapitalized.

 

[Desu Nota from Columbus]

Sorry...

My intial attempt assumes that silver will be at the beginning of the word.
Using the search as opposed to find might be better as search is not case sensitive.

=IF(ISNUMBER(SEARCH("silver", B2)), "Update price","N/A" )

Stop posting the same stuff I do... lol