IF function with multiple conditions

Hi,

I have such a problem.

I need to display "Certificate" in a given cell if specific words or parts of them are not contained in the HTML code.

If (B3) does not contain any text from the list in cell ($E$ 3), display 'Certificate', otherwise minus '-'.


Thank you for your help

Best wishes
Paul

I put the 'search' text in Cell D1 (you can modify or change it). Then I added a SEARCH function to an if statement. Cheers

Yes. It's that i need.

Thaks for help, greetings!