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)
@hagstrom , hope this helps
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?
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.