• 409K Members
• 10.9K Online
• 466K Conversations

New Contributor

# Help with formula to add markups based on the cost of the item

HOW DO I WRITE A FORMULA TO:

(a) ENTER A VARIABLE NUMBER IN CELL #1 (\$ COST); THEN

(b) ENTER A VARIABLE DECIMAL PERCENTAGE, eg 0.03 / 3%, IN CELL #2 (MARKUP); RESULTING IN

(c) COMBINED VALUE, CELL #3 (RETAIL PRICE)

5 Replies

# Re: Help with formula to add markups based on the cost of the item

@hagstrom , hope this helps

# Re: Help with formula to add markups based on the cost of the item

Hi Wyn,

Thanks for your reply. I'm having a bit of difficulty understanding how this "Community" works. You replied 'hope this works', but I don't see any solution following your reply. What do I have to do in order to see your solution for the formula?

Eric

# Re: Help with formula to add markups based on the cost of the item

It seems the picture I added didn’t show up

Formula is

=A1 * (1+B1)

Where A1 contains cost and B1 has 3%

# RE: Help with formula to add markups based on the cost of the item

السلام عليكم ماهي طريقة التخلص من الصيغة او عدم رؤية الصيغة

# Re: Help with formula to add markups based on the cost of the item

It is also possible to use something called defined names in place of cell references, so that 'price' becomes

= cost * ( 1 + markup )

If, at some later date, the markup were to differ according to the category of sales item, the definition of 'markup' would change but the formula for price would be unaltered.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies