Forum Discussion
ckinsey6
Feb 02, 2019Copper Contributor
If function in Excel
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) ne...
william97296
Feb 03, 2019Copper Contributor
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.