If Or famula for finding word in a sentance

Ammu - Aug 17, 2015 at 02:54 AM

Can anybody help to find ans for below question

if sentances are " HEDgroup people are in bench" "evals making count" "nothing in MIL"

i want the fomula if HED is there in sentance i wanted Apple or i wanted Berry.

i tried with the below formula but its not working