Sp Generator

[Excelsiordave]

Hi all,

Need to use either the Goal Seek Function or a nifty formula to generate an selling price to return a margin of 30%.

I have the cost info.

Any ideas.

Cheers,

Dave.

 

[njimack]

Like this?

Excel Workbook
	A	B	C
1	Cost	Margin	Selling price
2	100	30	130
Sheet1

 

[shg]

Sell price = cost / (1-margin)

E.g., for cost = $100.00, margin = 30%, price = $142.86