# How to Calculate Retail Price in Excel (2 Suitable Ways)

### Method 1 – Calculate the Retail Price from the Markup

Let’s assume the total cost to manufacture a bicycle is \$600. Revenue earned from the sale is \$800. The gross profit is \$800 – \$600 = \$200. Therefore, the markup is (\$200/\$600)Ã—100% = 33.33%.

We have a list of cost prices along with markup percentages. We’ll calculate the retail price for each cost value.

• Enter the following formula in cell D5.
`=B5*(1+C5)`
• AutoFill down the column.

### Method 2 – Calculate the Retail Price from the Margin

Consider the earlier example. The gross profit is \$200 while the revenue is \$800. Therefore, the margin is = (\$200/\$800)Ã—100% = 25%

Assume we have the margin percentages instead of the markup percentages.

• Apply the following formula in cell D5 to calculate the retail price.
`=B5/(1-C5)`

## Things to Remember

• Check whether you have the markup % or the margin % before calculating the retail price.
• Markup % is greater than the margin % for the same cost-profit combination.

<< Go Back to Selling Price | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF