Not sure I'm following your reasoning, I have rearranged your formulas.
In the first sheet, the selling price is an input -> you can calculate profit amount changing cell B6.
In the second, we calculate selling price from profit, and build the table. As you can see, cell E7 will never be > 62%.
Let me know whether this works for you, or I have misunderstood your model/request.
HTH,
Francesco
Bookmarks