I have a sheet containing currency in cell E10, quantity F10 and a sum in M10 (=F10*E10) In cell K10 I also use multiple words that would equal a dollar or percent discount. I would like to write a formula that would apply the discount to cell M10 if cell k10 contains one of the 4 words. example of words are Welcome21, Welcome22 and Welcome23 all equal $10 off the sum in cell M10 and Thanks10 equals 10% off the sum in cell M10