"Nitin Harkawat" wrote...
=if(search("Total",a1)=1,1,0)
where cell A1 contains the text
....

If A1 doesn't contain the substring Total, SEARCH will return a #VALUE!
error, so your formula would evaluate to #VALUE! rather than 0.