Gross margin
 

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

Gross margin
 

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

"Don Y" wrote:

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

Gross margin
 

"Don Y" wrote:

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.

Gross margin
 

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" wrote:



"Don Y" wrote:

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.

Gross margin
 

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

"Don Y" wrote:

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" wrote:



"Don Y" wrote:

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.