Gross margin

[Don Y]

When calculating gross profit margins using cost and sell price, what does
the formula look like?

 

[Eduardo]

Hi,
if ssles are in A1 and cost in B1 in C1 enter

=A1-B1

If you need to see the %GM in D1 you can enter
=C1/A1
format D1 as %

If this helps please click yes, thanks

 

[James]

When calculating gross profit margins using cost and sell price, what does
the formula look like?

If the cost is in A1 and selling in B1 the formula would be =(B1-A1)/A1
Format the cell for percentage.

 

[Don Y]

Thanks for the reply. It helped. Let's say i want to create a sheet that
will allow me to change the GP% by entering the desired GP and have it change
the sell price to reflect the GP i'm looking for. A1 is cost, A2 is sell
price, A3 is the cell i enter the desired GP percent which will automatically
change A2 sell price?

 

[James]

In A2 use this formula Cell A3 should be formatted percentage. A1+(A1*A3)