Home

If function in Excel

ckinsey6
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies