Calculate price discount multiplier from Manufacturers list given desired margin and cost

I can calculate the correct margin percentage with this formula MarginPrcnt = 1-(CostMultiplier/PriceMultiplier), see cell E14 given CostMultiplier & PriceMultiplier.

What would be the formula to calculate PriceMultiplier, given MarginPrcnt and CostMultiplier.?

I’m stuck on creating the formula in cell M1, given a new target margin, without working through the data examples in Range (“A6:M12”).

From a mathematical standpoint

Please Login or Register  to view this content.

Paul. That worked perfect. Thank you so much for your help, it's greatly appreciated. I couldn't remember my "math" enough to figure it out.