Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a percentage mark up
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a percentage bar chart in excel | Charts and Charting in Excel | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Creating a check mark box | Setting up and Configuration of Excel |