Creating a percentage mark up
On Sep 19, 8:34 pm, Randy Reno <Randy
wrote:
I am wanting to take a cost of a item in one cell and then apply a mark up
amount in another cell to then total that in a final cell. I am needing the
markup to be correct using the / factor. IE: 40% markup on a item costing
100.00 should be a ending number of 166.67.
Assumptions:
Cell A1 contains the item cost (IE: 100.00)
Cell B1 contains the percentage markup (IE: 40%)
Cell C1 contains the following formula: =A1/(100%-B1)
If you store the percentage as a decimal value (IE: .4 instead of
40%), you could use a formula like =A1/(1-B1), although it will yield
the same result as =A1/(100%-B1).
HTH
-Jeff-
|