| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
gross margin
i am trying to establish a fromule for product cost for a customer by going
backwards from their margin expectation and retail price |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
gross margin
Hi,
try =(price*(1-margin)) assuming the price is 1,200 the expected margin is 15% =(1200*(1-15%)) = 1,020 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "unojim" escreveu: i am trying to establish a fromule for product cost for a customer by going backwards from their margin expectation and retail price |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help in Developing a Multi-Level Gross Margin Chart | Charts and Charting in Excel | |||
| entering formulas gross margin % divide by Week Total Sales | Excel Worksheet Functions | |||
| Calculation of Gross Margin in a pivot table | Excel Worksheet Functions | |||
| gross profit margin formula | Excel Discussion (Misc queries) | |||
| How do I make a column that calculates gross margin percentage | Excel Worksheet Functions | |||
Linear Mode
