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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GP Formula Needed 5
How do i set up a cost - plus pricing method template on excel? 1
EXCEL TEMPLATE THAT CALCULATES PRODUCT PRICES 1
Help with formulae 3
spreadsheet with negitive numbers 1
formula calculation 2
template for quotations in excel 1
excel formula for markup and profit margin 3

Top