About 246,000 results
Open links in new tab
  1. Calculating Sale price from cost and Margin - MrExcel

    Jul 8, 2003 · Margin % = (Cost-Retail)/Retail so if we wanted to calculate the Retail price of an item based off a margin given we would follow a formula =24.9/ (1-.85) this would give you the sale price …

  2. Calculate sale price by setting profit margin formula - MrExcel

    Dec 23, 2014 · Hi all I am trying to find a formula for cell A3(sale price) that can be adjusted by entering a percentage in cell A2(margin) which will be the profit made from cell A1(cost price). Also I need …

  3. Formula for calculating eBay selling price - MrExcel

    Apr 18, 2019 · I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my costs: Item cost £1.72 Shipping …

  4. Formula for a sale price which has circular references

    Jan 10, 2024 · Working from selling price backwards is obviously easy, the issue is working forward from buy price, variable costs which are a percentage based on sale price and a target margin make it.

  5. Find cost if you know sales price and margin - MrExcel

    Dec 18, 2023 · Hello all. I'm looking for a simple calculation to find the original cost of an item if the Sales Price and Margin % are known.

  6. Find formula to drive sale price based on entering gross profit ...

    Jun 29, 2021 · Hi I’m after some expert help to find a formula that will do the following: I want to know the sale price of my goods, when I enter the gross profit percentage that I want to make (not …

  7. Formula to calculate desired profit margin, Acurately without Solver ...

    Dec 23, 2014 · Similar threads B Generate formula to calculate sell price with respect to buy price, buy& sell out fees and desired profit margin percentage (changing variable) Briefshallot8004 Jul 21, 2024 …

  8. Formula to work out Cost Price | MrExcel Message Board

    Aug 22, 2007 · Hi everyone, I'm having a mental block. I need to work out a formula to calculate the Cost Price of items, if i know the selling price and the GP%. Also...

  9. How to get the selling price if i know my UNIT COST & MARGIN

    Apr 17, 2015 · Markup is the amount by which the cost of a product is increased in order to derive the selling price. To use the preceding example, a markup of $30 from the $70 cost yields the $100 …

  10. Formula require to work out selling price based on NOG

    Jul 24, 2013 · NOG stands for Nett On Gross and is calculated by dividing cash margin ex VAT by retail sales including VAT. Whereas the standard method of working out retail margin is cash margin …