I am having so much problem trying to figure out funtions for Excel! I need to get the formula using the "if" function. I need to use the "if" function to say the that the items for sale (rings) need to have 5% added if they are getting personal engraving with their names. Can anyone help?
ckinsey - Let me know if this is what you're looking for. Please see below and attached.
Please look at the IF statement in cell D2. It reads, "If C2 = "Y" (Engravement applies), then return Price (C2) + (Price (C2) * Upcharge % (F2)). Otherwise, return just the price (C2). Let me know if this helps.