How about

=IF(ISERR(SEARCH("Dogs",A1)),B1,0)

--
Kevin Vaughn


"TMF in MN" wrote:

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.