I was able to do this with a single IF formula, but cannot exactly figure out how to do it with IFS to search the same cell for different strings of text.
Here is the formula I am using for the single IF statement:
=IF(SEARCH("silver",B5),"silver","N/A")
It is searching cell B5 for the term "silver" and then if found it returns "silver". If not it returns N/A. I would like to be able to search cell B5 for different terms ("black","red","blue") using the IFS formula.
Thank you in advance!
Aucun commentaire:
Enregistrer un commentaire