Calculating Sales price by Entering Gross Profit
 

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Calculating Sales price by Entering Gross Profit
 

Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100


Regards,

Alan


"Spawnof" wrote in message
oups.com...
I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Calculating Sales price by Entering Gross Profit
 

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

oups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Many thanks!

Calculating Sales price by Entering Gross Profit
 

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

oups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

Calculating Sales price by Entering Gross Profit
 

Sorry, I don't think straight after midnight, lol. I think this is what you
are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan


"Spawnof" wrote in message
oups.com...
On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

oups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

Calculating Sales price by Entering Gross Profit
 

Ooops, that second formula should be

=(A1/(1-$B$1)) If margin is constant across all goods.

Regards,

Alan


"Alan" wrote in message
...
Sorry, I don't think straight after midnight, lol. I think this is what
you are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan


"Spawnof" wrote in message
oups.com...
On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

oups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

Calculating Sales price by Entering Gross Profit
 

On Mar 5, 1:57 pm, "Alan" wrote:
Sorry, I don't think straight after midnight, lol. I think this is what you
are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan

"Spawnof" wrote in message

oups.com...

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

groups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

This does still not appear to work.

e.g The sale price of 150 (cost) at 33.33 margin (%) is 225

when I use your formula it doesn't equate to this - comes out as a
minus figure in fact?

Calculating Sales price by Entering Gross Profit
 

Well yes, if you are using actual % values.
=A1/(1-B1/100)
or
=100*A1/(100-B1)

NickHK

"Spawnof" wrote in message
oups.com...
On Mar 5, 1:57 pm, "Alan" wrote:
Sorry, I don't think straight after midnight, lol. I think this is what
you
are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan

"Spawnof" wrote in message

oups.com...

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

groups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

This does still not appear to work.

e.g The sale price of 150 (cost) at 33.33 margin (%) is 225

when I use your formula it doesn't equate to this - comes out as a
minus figure in fact?

Calculating Sales price by Entering Gross Profit
 

On Mar 9, 9:38 am, "NickHK" wrote:
Well yes, if you are using actual % values.
=A1/(1-B1/100)
or
=100*A1/(100-B1)

NickHK

"Spawnof" wrote in message

oups.com...

On Mar 5, 1:57 pm, "Alan" wrote:
Sorry, I don't think straight after midnight, lol. I think this is what
you
are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan

"Spawnof" wrote in message

roups.com...

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

groups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

This does still not appear to work.

e.g The sale price of 150 (cost) at 33.33 margin (%) is 225

when I use your formula it doesn't equate to this - comes out as a
minus figure in fact?

that's what I was after. Many thanks...

Calculating Sales price by Entering Gross Profit
 

On Mar 9, 3:04 pm, "Spawnof" wrote:
On Mar 9, 9:38 am, "NickHK" wrote:





Well yes, if you are using actual % values.
=A1/(1-B1/100)
or
=100*A1/(100-B1)

NickHK

"Spawnof" wrote in message

roups.com...

On Mar 5, 1:57 pm, "Alan" wrote:
Sorry, I don't think straight after midnight, lol. I think this is what
you
are looking for:

=(A1/(1-B1)) ' Each item has it's own margin

=(A1/(1-$B1)) ' If margin is constant across all goods.

Regards,

Alan

"Spawnof" wrote in message

roups.com...

On Mar 1, 5:34 pm, "Alan" wrote:
Formula in C1 where A1 is Cost of Goods & B1 is Profit Margin.

=A1*(100+B1)/100

Or use this if you want to set the same profit margin for all goods:

=A1*(100+$B$1)/100

Regards,

Alan

"Spawnof" wrote in message

groups.com...

I am trying to calculate Gross Profit on a worksheet using the
following

column a : I enter cost of goods
column b: I enter required profit margin as percent
column c: excel calculates the sale price

Any help much appreciated

Actually this does not do what I want it to do Gross profit is not the
same as a percent the formula is. The formula for GP is:

profit / selling price * 100

This does still not appear to work.

e.g The sale price of 150 (cost) at 33.33 margin (%) is 225

when I use your formula it doesn't equate to this - comes out as a
minus figure in fact?

that's what I was after. Many thanks...- Hide quoted text -

- Show quoted text -

C1=(C1*B1)+A1