Press Esc to close
**5-22-2015** | Response Time: 3 days

How to Choose Your

Excel Expert Type...

Select the field of expertise that best matches your question so we can assign the appropriate expert to handle your question. If you donâ€™t know - select 'General Expert'.

Why open an account with

Excel-Formulas.com?

Excel-Formulas.com?

- Get access to our Excel experts
- One central location for all your questions and answers
- And of course, so you can get your answer!

E-Mail address: |

First visit |

Already registered |

**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!

- 54 Training Videos
- 90-Second Formula Exercises
- Detailed Exercise Solutions
- And more