535243 EXCEL FORMULAS NEEDED

I need two excel formulas created for me. The first: If C2 contains the word "ball" print ball-earrings in D2 If C2 contains the word "clip" print clip-on-earrings in D2 If C2 contains the word "cuffs" print ear-cuffs in D2 If C2 contains the word "dangle" print dangle-earrings in D2 If C2 contains the word "jackets" print earring-jackets in D2 If C2 contains the word "hoop" print hoop-earrings in D2 If C2 contains the word "stud" print stud-earrings in D2 If C2 contains none of the above words, print earrings in D2 The second formula: Please see attached excel 2003 file. If you can do this for me, please place a bid. :)