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

Occasional Visitor

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 ! 

1 Reply

@Elieliza 

As variant

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