An analogue of "search for a solution" for Google Excel?

Question

excel

Prompt for an analogue of the standard in EXCEL "Search for Solutions"
For Google Excel.
In fact, how to add "Search for Solutions" to Google Excel

Answer 1

I suspect that there is no such functionality in Google Sheets. However, it is quite possible to write a js macro that will perform the necessary operations.

Answer 2

The tools are available as an add-on
https://gsuite.google.com/marketplace/app/goal_see...
https://gsuite.google.com/marketplace/app/solver/5...
https://gsuite.google .com/marketplace/app/opensolv...