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
Highlighted
Highlighted

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
delete one marging
fred83 in Excel on
0 Replies
Link Sheet 2 to Sheet 1 but 'only' if........
WhopRBopr1 in Excel on
2 Replies
Database Structure
leuki in Excel on
0 Replies
Unable to delete empty rows and columns
G_Torres in Excel on
5 Replies
Help with simple formulas please
nursekimberley in Excel on
4 Replies