Find solutions that minimize or maximize a function defined in a worksheet's cell.


Version: 2021

Type: Features

Category: Analysis

Subcategory: General

Jira: APPS-726


Download Optimization Solver app from the page and install the app.

Operation:

  1. Highlight the Objective Function cell in the worksheet. Launch the app.

  2. Drag and drop columns for Initial Values and Solution.

  3. In the Settings branch, choose target, method, bounds and iteration options.

  4. Click OK button. Results in the worksheet and graph will be updated.