+ Reply to Thread
Results 1 to 8 of 8

Need Backwards Profit Margin Formula

  1. #1
    Registered User
    Join Date
    04-14-2009
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need Backwards Profit Margin Formula

    Good morning all,

    I am trying to develop a formula that can give me the cost price by inputting the sell price and profit margin.

    My sell price is $1.25 I want to input a profit margin of 20% and have the result be my desired cost.

    Any help would be welcome.

    thanks
    way~

  2. #2
    Registered User
    Join Date
    03-20-2009
    Location
    Stirling, Scotland
    MS-Off Ver
    2007
    Posts
    2

    Re: Need Backwards Profit Margin Formula

    cell A1: 1.25 (sell price)
    cell A2: 20 (profit margin)

    cell A3: =A1-(A1*(A2/100))

    Based on the input values above, the answer (A3) should be $1.00

    See how that goes.

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Need Backwards Profit Margin Formula

    A3 =A1*(1-A2) where A2 is 0,20 and A1 1,25

  4. #4
    Forum Contributor
    Join Date
    04-14-2009
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Need Backwards Profit Margin Formula

    just times the sell price cell by 0.8 e.g =a1/.8

  5. #5
    Forum Contributor
    Join Date
    04-14-2009
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Need Backwards Profit Margin Formula

    Sorry, multiply by 0.8 e.g a1*.8

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Need Backwards Profit Margin Formula

    Yes, but with first way he can change profit margin

  7. #7
    Registered User
    Join Date
    04-14-2009
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need Backwards Profit Margin Formula

    Thanks Danwall works like a charm saved me hours.

    way~

  8. #8
    Registered User
    Join Date
    03-20-2009
    Location
    Stirling, Scotland
    MS-Off Ver
    2007
    Posts
    2

    Re: Need Backwards Profit Margin Formula

    no worries

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1