IF Statement Based on Text Value in Cell

[acool]

Hi Everyone,

I would like to create an IF Statement which states that if my product category on the right is equal to cell value of "Protein,", "Plant Protein," or "Protein Gainer" then discount 20% off the Original Price. If Product category is not one of the ones listed above, I would like to use the original price provided. Any help or insight would be greatly appreciated! Thank You!

 

[Joe4]

If your product is in cell A2 and your price in B2, put this formula in cell C2:

=IF(ISNUMBER(SEARCH("protein",A2)),B2*(1-20%),B2)

Note that you can replace the "20%" with a cell reference, if that is being stored somewhere.

 

[Fluff]

Maybe like

=B2*(1-IF(COUNTIFS(A2,"*protein*"),$D$2,0))