Goal Seek
goal_seekAdjust a specified constant cell until a formula cell reaches a target value, then save the result. Stops at 0.001 tolerance within 100 iterations; leaves workbook unchanged if it cannot converge.
Instructions
Goal Seek: change the constant changing_cell until the formula in cell equals
target, and store it. Stops within 0.001 after at most 100 iterations; if it does not
converge, nothing is changed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | Formula cell to set. | |
| path | Yes | ||
| sheet | Yes | ||
| target | Yes | The value it should reach. | |
| changing_cell | Yes | Constant to change. |