I'm trying to figure out how to identify 'if' a list of items in one cell contains a value or string.
Cell A1 contains "sites, sheets, docs, slides".
I want cell B1 to display a 1 'if' cell A1 contains the string "sites".
=if(A1 ?????? "sites", 1,0)
I'm not sure what to replace the
?????? with in the above formula OR if this formula is possible. Any ideas on how to accomplish the desired outcome is greatly appreciated.