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
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Finding the data and to color code it
NishantSalunkhe in Excel on
3 Replies
=Function() returning incorrect date in some cells
tom_gowen in Microsoft Teams on
1 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies