Formula that 'contains' a specific word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In this scenario I would like column C to show 0 for any cell in column a
that contains the word "dogs."

a b c c should be
1 xx dogs 33 0
2 rr cat 16 16
3 zz dogs 5 0

Thank you.
 
The formula in C2 would be: =IF(A2="dogs",0). You must use quotes for any
text in a formula. Then spread this formula down column C.
 
That does work except for the variable text that is contained with the word
dogs. I would like it to return the value of 0 if the text said "xx dogs" or
"yy dogs" or just "dogs". Can you incorporate this variable into a formula?
 

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

Lookup_finding all the corresponding cell... 5
Data Consolidation formula 1
Lookup question 6
Average # in total group with multiple criteria? 8
Can I use a formula to filter data? 8
Function for an array 3
Excel 2003 formula 4
string lookup combined with SUM 4

Back
Top