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

Copper Contributor

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

@Wyn Hopkins 

 

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

It seems the picture I added didn’t show up

Formula is

=A1 * (1+B1)

Where A1 contains cost and B1 has 3%
السلام عليكم ماهي طريقة التخلص من الصيغة او عدم رؤية الصيغة

@hagstrom 

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.