Results 1 to 13 of 13

Profit margin formulas

Threaded View

  1. 10-23-2013, 08:02 AM #1
    Allgermanparts
    Allgermanparts is offline
    Registered User
    Join Date
    03-05-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2016
    Posts
    79

    Profit margin formulas

    Hi All,
    This may be a dumbo question or not even the right forum but I have cost price lists from suppliers which I want to calculate the selling price to make certain margins. So an oil filter costs me 1.99 and I want to sell at 3.58 to make 45% so I would have something like I have done on my attached sheet. Problem is I have to use trial and error to work out what the formula figure should be. How can I work out what the cost price cell needs to be multiplied by to give each profit margin e.g 25%, 30% etc? Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. easy one - margin % from revenue and profit?
    By equinox101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2013, 05:52 AM
  2. Setting up variable formulas for to determine profit margin
    By killahcheese in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2013, 03:04 PM
  3. Need Backwards Profit Margin Formula
    By waywrdchld in forum Excel General
    Replies: 7
    Last Post: 04-14-2009, 09:56 AM
  4. Profit Margin Trend
    By uplink600 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 11:15 AM
  5. [SOLVED] gross profit margin formula
    By julmcgrath in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1