Apr 26 2019 04:18 PM
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)
Apr 26 2019 04:44 PM
@hagstrom , hope this helps
Apr 26 2019 06:10 PM
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
Apr 26 2019 09:37 PM
Apr 27 2019 02:56 AM
Apr 27 2019 03:50 AM
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.