Search within cell

[Gee...]

I need to search within a cell. I'm searching for the word
"fuse"...sometimes they leave off the "e" or add "ing" so I'm really
searching for "fus".

I want to go into Column C and say something like:

"If B1 contains "fus" then Yes else No."

B1 might contain something like:
"Replaced fuses in main generator" or
"A7438Bfuse" or
"Tray fusing aligned"

Thank you in advance for your help.
G

 

[JE McGimpsey]

One way:

=IF(COUNTIF(B1,"*fus*"),"Yes","No")

alternative

=IF(ISERR(SEARCH("fus",B1)),"No","Yes")

another:

=COUNTIF(B1,"*fus*")

and custom format the cell (Format/Cells/Number/Custom: "Yes";;"No")