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!
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!