Help me to manage covid vaccination in my health center pleaze !

[Elieliza]

Hello everybody,

I would like to find the right formula to get this :

if cell A1 contains the word "astrazeneca" OR the word "comirnaty" the "yes" or "no"

Thanks you very much ! 

[#2]

@Elieliza 

As variant

=IF( SUM(COUNTIFS(A1, {"*astrazeneca*","*comirnaty*"})), "Yes", "No")