| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| future value and gross profit. | Excel Discussion (Misc queries) | |||
| entering formulas gross margin % divide by Week Total Sales | Excel Worksheet Functions | |||
| gross profit | Excel Worksheet Functions | |||
| how to work out gross profit on items | Excel Discussion (Misc queries) | |||
| How do I calculate profit as a % of Sales price | Excel Discussion (Misc queries) | |||
Hybrid Mode
