Forum Discussion
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
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.
- السلام عليكم ماهي طريقة التخلص من الصيغة او عدم رؤية الصيغة
hagstrom , hope this helps
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%
