Home

If function in Excel

Highlighted
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
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies