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