How to optimize initial values ​​in EXCEL?

Question

excel

Given a table with three rows and a formula that uses the data of this table (see screenshot 1), then these formulas use the result of the first one, also relying on the data of this table (see screenshot 2) how can I auto-select data in the table so that the final the formula had the required value (namely, more than 20). The first column in the table does not change

Answer 1

Tab "Data" -> "Analysis "what if"" -> "Sampling" You can find instructions from
here )

Answer 2

Plugin for Excel Search solutions
This is the answer to your question. Learn and be able to customize its work as you need.