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

O.K., sounds like a fairly simple set of requirements. What's your
question specifically?

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Clint" wrote in message
:

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

Hi Clint,

With your cost price in A1
Put this in B1
=A1*1.17

HTH
Martin

"Clint" wrote in message
...
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

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

"Ben M. Schorr - MVP (OneNote)" wrote:

O.K., sounds like a fairly simple set of requirements. What's your
question specifically?

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Clint" wrote in message
:

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

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

"MartinW" wrote:

Hi Clint,

With your cost price in A1
Put this in B1
=A1*1.17

HTH
Martin

"Clint" wrote in message
...
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

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

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

"MartinW" wrote:

Hi Clint,

With your cost price in A1
Put this in B1
=A1*1.17

HTH
Martin

"Clint" wrote in message
...
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

That's it!
cheers Martin
Clint

"MartinW" wrote:

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

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

"MartinW" wrote:

Hi Clint,

With your cost price in A1
Put this in B1
=A1*1.17

HTH
Martin

"Clint" wrote in message
...
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

You're Welcome. Thanks for posting back.

Martin


"Clint" wrote in message
...
That's it!
cheers Martin
Clint

"MartinW" wrote:

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

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

"MartinW" wrote:

Hi Clint,

With your cost price in A1
Put this in B1
=A1*1.17

HTH
Martin

"Clint" wrote in message
...
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