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...
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.