Changes

Jump to navigation Jump to search
no edit summary
\n\1\2\n\1
 
=if(isnumber(search("blah",B2))=TRUE,1,0)
where blah is the substring (what you're searching for), B2 is the string (what your searching in) and 1 represents that it's present and 0 means it isn't.
 
=sum(A1:C1)
This just sums the cells from A1 to C1
216

edits

Navigation menu