Formula that 'contains' a specific word

T

TMF in MN

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.
 
R

Richard O. Neville

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.
 
T

TMF in MN

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?
 
Top