Check a cell to see if it contains something then put in custom content somewhere else

Hello!

I need excel to check a cell to see if it contains the phrase "SHG." If it does I want it to return 99.995% to a different cell. If it doesn't contain SHG I just want it to return "Remainder." This is important because there is SHG Zinc Balls, SHG Zinc Slabs, SHG Zinc Anodes. If it isn't SHG then the Remainder is higher than 99.995%. I was thinking it would look something like this:

=IF(ISNUMBER(SEARCH("SHG",A1041))=TRUE,"99.995%","Remainder")

I did get that to return "Remainder," but when I typed in SHG it still returned as "Remainder." I am thinking my problem is obviously with my search function. I think it is intended to work and return an entire cell and not specific text. Is this my issue? Can it work the way I want it to?

Just kidding... I figured it out. =IF(ISNUMBER(SEARCH("SHG",A1041)),"99.995%","Remainder") It did work I just had the wrong cell in there that it was checking.

Simple mistake. Glad you found it.

Thanks for the rep!