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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> >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!

On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> >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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>> >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
>

Ooops, that second formula should be

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

Regards,

Alan


"Alan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>>>
>>> news:(E-Mail Removed)...
>>>
>>> >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
>>
>
>

On Mar 5, 1:57 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> >>news:(E-Mail Removed)...
>
> >> >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?

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

NickHK

"Spawnof" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mar 5, 1:57 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
> >
> > news:(E-Mail Removed)...
> >
> > > On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
> >
> > >>news:(E-Mail Removed)...
> >
> > >> >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?
>

On Mar 9, 9:38 am, "NickHK" <TungChe...@Invalid.com> wrote:
> Well yes, if you are using actual % values.
> =A1/(1-B1/100)
> or
> =100*A1/(100-B1)
>
> NickHK
>
> "Spawnof" <spaw...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
> > On Mar 5, 1:57 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> > >news:(E-Mail Removed)...
>
> > > > On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> > > >>news:(E-Mail Removed)...
>
> > > >> >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...

On Mar 9, 3:04 pm, "Spawnof" <spaw...@gmail.com> wrote:
> On Mar 9, 9:38 am, "NickHK" <TungChe...@Invalid.com> wrote:
>
>
>
>
>
> > Well yes, if you are using actual % values.
> > =A1/(1-B1/100)
> > or
> > =100*A1/(100-B1)
>
> > NickHK
>
> > "Spawnof" <spaw...@gmail.com> wrote in message
>
> >news:(E-Mail Removed)...
>
> > > On Mar 5, 1:57 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> > > >news:(E-Mail Removed)...
>
> > > > > On Mar 1, 5:34 pm, "Alan" <R...@cinci.rr.com> 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" <spaw...@gmail.com> wrote in message
>
> > > > >>news:(E-Mail Removed)...
>
> > > > >> >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