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