Multiple ifs in a text

[cadineshkumar]

Hello Members,

I have a column containing different text, if want to find two words in this text and if the text contains either of the words than the result should be "Letter of credit" otherwise the result should be "Others". The word which i want to find are "LC" or "L/C". I donot want to user filter. The example with suitable answer is as attached.

Thanks in advance. Sorry for English.

[samba_ravi]

C2=IF(SUM(COUNTIF(B2,{"*L/C*","*LC*"})),"Letter of Credit","Others")
Try this and drag towards down

[cadineshkumar]

Thanks a Lot!!!