If function in Excel

New Contributor

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?


2 Replies

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.


Personal Engravement Upcharge.png

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies