Calculate Retail Price based on desired profit margin - Excel Help …
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 …
[SOLVED] Calculation of Gross Margin in a pivot table - Excel Help …
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.
Formula to Calculate Discount % for Set Margin - Excel Help Forum
Jan 25, 2022 · Re: Formula to Calculate Discount % for Set Margin % Please update your profile or confirm that you are still using Excel 2007 - this is important.
Is it possible to reverse / rearrange my margin formula - Excel …
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 …
Calculate Sales Price to achieve margin [SOLVED] - Excel Help Forum
May 2, 2023 · Hello, I'm trying to calculate a sales price to achieve a target margin taking into account some Vat. For example Cost Price (C) : 19 Sale Price (S): 22 Vat = 1/6th of profit
need an Excel formula to reverse calculate selling price from Cost …
May 6, 2025 · Re: need an Excel formula to reverse calculate selling price from Cost & GPM your numbers in your example don't work. If you have a 28.50 product and you want to have a 30% …
Calculating Negative Gross Margin - Excel Help Forum
Oct 11, 2012 · Re: Calculating Negative Gross Margin In principle, the sales price cannot be a negative number....please recheck if "sell = -5" is indeed correct. However, the gross profit can …
Work out cost price of a product through a target RRP - Excel …
Oct 16, 2019 · Hello, I am trying to put together an excel sheet which calculates what the cost price of a product would be based on a target RRP that i enter. I would like it to be able to be …
margin calc [SOLVED] - Excel Help Forum
Mar 12, 2005 · Can anybody tell me the best formula to use to calculate the profit margin between two number when this maybe plus or minus
Solved Gross profit margin with Vat - Excel Help Forum
Jun 13, 2019 · Net Margin Formula Using SUM= To Calculate Gross Margin Cells By jezrp22 in forum Excel Formulas & Functions Replies: 4 Last Post: 02-26-2015, 08:41 PM