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,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Excel ignore formula 8
Sumproduct with if statement 4
LOOKUP function different? 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Displaying a range based on a cell's contents 3
Drop-down list and error message 1
MS Excel help 6

Back
Top