Mar 24 2021 02:39 AM
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 !
Mar 24 2021 02:53 AM
@Elieliza
As variant
=IF( SUM(COUNTIFS(A1, {"*astrazeneca*","*comirnaty*"})), "Yes", "No")