how do i set up a profit margin formula

W

wayne

new to excel-- i would like to set up a formula to calculate the margin
percentage.

ex -- cost divided by retail= markup, markup divided by 1. the markup

1.00/1.50 = .667

.667/1.667=40% gross margin
 
E

Eduardo

Hi Wayne,
In your example the margin is 50% not 40% the formula to use is

Cell A1 = Selling price
Cell A2=Cost

=1/(1+(A2/A1))

other way is to simple deduct the cost from the Selling price divided by 100
=(A1-A2)/100
 
E

Eduardo

Hi Wayne,
In your example the margin is 50% not 40% the formula to use is

Cell A1 = Selling price
Cell A2=Cost

=1/(1+(A2/A1))

other way is to simple deduct the cost from the Selling price divided by 100
=(A1-A2)/100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula for markup and profit margin 3
gross profit margin formula 2
Profit Margin 1
margin formula 2
Calculate Margins 3
Margin/markup formula for Excel 3
Calculations formula 6
How do I create 2 formulas that faily more eloquently? 2

Top