Calculate Retail Price

Press Esc to close

Question:

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.

Answer:

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

=D5/45%

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