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.