"bob" wrote...
I want to check a cell for the word "Total." The cell contains additional
text before the word Total. If the Total is found, I want to populate the
cell containing the formula with 1. If not, populate it with 0.
....

If Total always appears at the end of the string, try

=--(RIGHT(TRIM(x),5)="Total")

Otherwise, another alternative using only one function call,

=--(SUBSTITUTE(x,"Total","")<x)