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'.
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.