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) need to have 5% added if they are getting personal engraving with their names. Can anyone help?
- william97296Copper 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.
It looks like duplication of this https://techcommunity.microsoft.com/t5/Excel/If-function-in-Excel/m-p/329774/highlight/false#M24981