Calculate Retail Price based on desired profit margin - Excel Help Forum
Jan 12, 2016 · Hi, I have an excel sheet containing products which I sell and I am trying to work out a formula to give me a retail price (selling price) based on a desired profit margin taking into account all …
Is it possible to reverse / rearrange my margin formula - Excel Help …
Jun 28, 2024 · Hello, I have an Excel formula that calculates my projected margin (G) based on the product price (F) I enter. How can I reverse / rearrange my formula to calculate product price (F) …
Margin/markup formula for Excel - Excel Help Forum
Sep 19, 2009 · Margin/markup formula for Excel I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is …
Calculating product profit and margin - Excel Help Forum
May 14, 2025 · Re: Calculating product profit and margin You'll need VBA for this. A cell can contain either a formula or a hard-coded value, but not both.
Determining Margin Formula, I know cost and margin desired.
Jun 15, 2018 · Thanks in advance for any help offered. I need an Excel formula that will tell me my sales price if I know my cost and desired margin. I have searched for hours and tried several suggested …
Calculation of Gross Margin in a pivot table - Excel Help Forum
Apr 5, 2006 · Hello everyone I am trying to calculate the Gross Margin ( (Sales-cost)/Sales ) within a pivot table so the total calculate the gross margin of the total sales and Total cost. (The Average DO …
How to calcuale a selling price based on a minimum gross margin
May 10, 2005 · I have to achieve a minimum gross margin of cell (V49) and it equals 47% I want to put in cell (A42) the percentage I have to add onto my original selling price of (S42) to achieve a (V49) …
Reverse calculation for profit - Excel Help Forum
Jun 16, 2010 · Reverse calculation for profit Hello, I need a formula where I can say to Excel in a cell I want a profit of $2 for example and it'll calculate the item price I need to set to the product. Thank you …
Formula to Calculate Discount % for Set Margin - Excel Help Forum
Jan 25, 2022 · Formula to Calculate Discount % for Set Margin % Hi All, Just need a bit of help reverse engineering a Margin % formula. So I have Gross Price, Discount %, Net Price, Cost, Margin and …
Calculating Target based on Percentage (gross figure) - Excel Help Forum
Mar 30, 2021 · Calculating Target based on Percentage (gross figure) I have a list of prices in Excel of which currently have a set Gross Price Percentage based on the cost and selling price, but what I …