+ Reply to Thread
Results 1 to 4 of 4

Calculate selling price with the cost and margin%

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    south africa
    MS-Off Ver
    office 2013
    Posts
    2

    Calculate selling price with the cost and margin%

    Hi Guys,

    I have been spending hours googling and i am not coming right.

    If my cost price $20 and my markup is 30%. How would i get the selling price using a formula.

    A1=cost C1=markup% C1=Selling Price

    Kind Regards
    Gerald

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Calculate selling price with the cost and margin%

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    12-21-2015
    Location
    United States
    MS-Off Ver
    2016
    Posts
    62

    Re: Calculate selling price with the cost and margin%

    Imagining you meant D1 = the selling price after the markup since both values cannot exist in the same cell.

    =SUM(A1,A1*$C$1)
    Last edited by Skiptomylou; 03-20-2018 at 03:55 PM.

  4. #4
    Registered User
    Join Date
    03-20-2018
    Location
    south africa
    MS-Off Ver
    office 2013
    Posts
    2

    Re: Calculate selling price with the cost and margin%

    Thank you, avk forumula has worked for me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-28-2017, 09:20 AM
  2. Dealer discount, margin, cost of goods but what will the selling price be?
    By Calculation1956 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2016, 01:36 PM
  3. [SOLVED] Selling Price When Only Costs and Gross Margin Are Known
    By Vladamir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2015, 06:05 AM
  4. Calculating a selling price from a given margin.
    By rwl518p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2015, 05:36 PM
  5. [SOLVED] Setting a selling price based on cost price and order quantity
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 08:07 AM
  6. [SOLVED] Calculate Sales price with Net Margin 10% Goal, if Cost goes up or down
    By Bitto in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-22-2013, 07:26 AM
  7. How to calcuale a selling price based on a minimum gross margin
    By dougie8rown in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-10-2005, 08:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1