If Or Search multiple cells to look for a specific word

[beraned1218]

I am trying to check 2 different cells to see if either one has a word and respond with TRUE if either condition is met.
I am using the formula: =IF(SEARCH("bearing",B2,1),"true",IF(SEARCH("bearing",C2,1),"true","false"))

To check first cell B2 and see if the word "bearing" is in that cell.
If it is not there then check cell c2 to see the word "bearing" is there

As you can see in my shared spreadsheet only if the word "bearing" is present in both cells will I get a return of "true"
I want to know if it is in one or the other or both cells?

 

[Scott Huish]

=OR(ISNUMBER(SEARCH("bearing",B2)),ISNUMBER(SEARCH("bearing",C2)))