D
Don Y
When calculating gross profit margins using cost and sell price, what does
the formula look like?
the formula look like?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
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
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
J
James
Don Y said: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.
D
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?
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?
J
James
In A2 use this formula Cell A3 should be formatted percentage. A1+(A1*A3)