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
|