Help with CONTAINS formula
I currently have a formula that is looking for a value in one cell and if it matches another it throws out a yes/no.
What I want to do is amend it so it looks for certain text and have it throw out a yes/no if it matches the other cell value.
Formula is: =IF(AND([ILG (min)(mm)]@row <= 0.249, [Finish (Outer plating only)]@row = "Matte Sn"), "Yes - M- Required", "No - Not Required")
I need the [Finish (Outer plating only)]@row = "Matte Sn") section to become a CONTAINS and look for "Sn"
(In the above instance the 'Fine Pitch Coating Req' should be yes)
Any help is most appreciated.
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!