Excel If Function

  • Thread starter Thread starter Nick Read
  • Start date Start date
N

Nick Read

Can you let me know how I write an IF formula in an
excel that will return a TRUE value in the cell D2 if the
cell A2 contains the word Alcohol and cell A2 contains
the word Drugs and cell C3 contains the word anger.

Thanks Nick Read
 
One way:

D2: =AND(COUNTIF(A2,"*Alcohol*"), COUNTIF(A2,"*Drugs*"),
COUNTIF(C3,"*anger*"))

or

D2: =IF(AND(COUNTIF(A2,"*Alcohol*"), COUNTIF(A2,"*Drugs*"),
COUNTIF(C3,"*anger*")),TRUE,"")
 
Back
Top