IN EXCEL SOLVER For an equation with multiple possible answe

IN EXCEL SOLVER:

For an equation with multiple possible answers, how does the Solver decide what answer to give? It gives all of them It gives the answer closest to initial guess It gives the \'right\' answer It gives the smallest answer It gives the largest answer

Solution

By the Simplex LP Solving technique, you can locate a globally optimal answer given enough time however you may have to resolve for a solution that’s close to finest found in a more sensible amount of time. By the GRG Nonlinear and Evolutionary Solving techniques, you should guess a good but not get finest solution.