One-Way Data Table - Calculating The Selling Price By The Profit Increase

[zanshin777]

I want to calculate the selling prices (H10-Q10) by the profit increase (H9-Q9) with One-Way Data Table.

How can I do that?

[Bo_Ry]

Put constant in H2

G10 =E5 or E6

[Hydraulics]

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

[zanshin777]

Thank you very much for the answers. Bo_Ry's solution works for me.