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
=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.