I have attached a sample from the worksheet.

I have formulas set up to calculate the Net Margin (cells M3 > M7) for products i sell if i set the Gross Margin (Cells D3 > D7) using a set % in D1

This is great but what i really need is to understand what Gross Margin amount i shoudl add in order to achieve a set Net Margin.

In the worksheet , you can see that the Net Margin pf products ranges from 7% to 12% , ideally i want to be able to stipulate that i want all items to have 10% Net Margin and it would work out the Gross Margin i need to add to product.sample.xlsxsample.xlsx

It is like the sample worksheet but backwards...if that makes any sense