hi,
you already have the formula
if cost = e16 and gm = f17 then formula in e17 would be
=e16/(1-f17)

the other formula would be much the same except using the % instead of a
cell reference.
in g17, =e16/(1-.15)
in h17, =e16/(1-.2)
in i17, =e16.(1-.25)
ect, ect

regards
FSt1

"SeeStation" wrote:

I need to calculate gross margins and prices at different levels of GM:

Non-Excel Formula to calculate Selling price using gross margin
Selling Price = Cost / (1-GM%)

For example, if your product costs $100 and the required gross margin is
40%, then your Selling Price = $100/(1-0.4) = $100/0.6 = $166.6


So in my worksheet E16=cost E17=Current Selling Price
I want to put my current GM in F17,
I want to get a selling price for GM at:
15% in G16
20% in H16
25% in I16
30% in J16
35% in K16

Any ideas?