Combination of if and find function possible ?

Hi,
I have searched the forums but could not really find a solution for my problem. For you experts this should be simple.

I have one column (say column b) that contains account descriptions, which consist of multiple words (like a sentence). Some of these descriptions contains a certain german word, while all the others are english.

Is there such a kind of formula that does the following? If the word x is found in cell b2 then b1 should be xy. If not found in be it should say zero or blank.

Thanks in advance for your help. I hope it is clear.

Bye,
WJ.

In B1, you can enter this forumla (assuming you are checking A1 for the german word):

=IF(ISNUMBER(FIND("German_Word",A1)),"XY",0)

Let me know if that helps.

Thanks that is exactly what I need..!
Many thanks for the quick answer

Bye,
WJ.

Happy to help.