I'm trying to figure out how to identify
IF a list of items in one cell containing a value or string.
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 unsure 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.