hi,
you already have the formula
if cost = e16 and gm = f17 then formula in e17 would be
=e16/(1f17)
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:
>
> NonExcel Formula to calculate Selling price using gross margin
> Selling Price = Cost / (1GM%)
>
> For example, if your product costs $100 and the required gross margin is
> 40%, then your Selling Price = $100/(10.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?
