Calculate Retail Price

Press Esc to close


I need a formula to calculate the retail price of an item with a 55% gross margin. I have the Cost of Good Sold amount but can't figure out the formula that would give me the retail accounting for the COGS being 45% of retail price.


The formula is actually pretty simple. Let's assume your cost of goods sold is in cell D5, then the formula to calculate price would be


Since multiplying the full price by 45% will give you the cost of good sold, you can reverse the formula and divide the cost of goods sold by 45% and get the full price.

Tags: Math

Enter your email and get everything you need to know about Excel Formulas!

Free Training Includes :

  • 54 Training Videos
  • 90-Second Formula Exercises
  • Detailed Exercise Solutions
  • And more
Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us