In a conditional statement is there any way to use some sort of "Like"
instead of just =, !=, ? I have a column with values similar to
value=10, value=12, value=50. Is there any way to count the number of
occurrences of "value"? The =if(A1="value",1,0) doesn't work because
its looking at the entire cell value, what I'd like is some sort of
=if(A10 LIKE "value,1,0) is this possible?