excel pricing template

C

Clint

I would like to set up or obtain a excel template or function to work out
sell price as in cost plus 17% gross profit etc
 
C

Clint

I would like to set up a template where i can enter a cost price and enter a
gp% to get a sell price
 
C

Clint

Hi Martin,
This adds on or marks up 17%, what i am after is the sell price if i wanted
17% GP margin?
Clint
 
M

MartinW

Hi Clint,

Try this,
With your cost price in A1
Your GP margin in B1
Put this in C1 =A1/(100-B1)*100

This assumes that your input in B1 is a whole number,
if it is a percentage then take out the zeroes like this
=A1/(1-B1)

HTH
Martin
 
C

Clint

That's it!
cheers Martin
Clint

MartinW said:
Hi Clint,

Try this,
With your cost price in A1
Your GP margin in B1
Put this in C1 =A1/(100-B1)*100

This assumes that your input in B1 is a whole number,
if it is a percentage then take out the zeroes like this
=A1/(1-B1)

HTH
Martin
Click to expand...
 
Top