AX1370
Goal Seek command
Use the Goal Seek command to perform goal seek calculations on a file. Goal Seek is an Excel feature that dynamically adjusts an input value to achieve a specified target result for a formula. For more information on how Goal Seek works, see the Microsoft Excel documentation.
Can be used in
- Axiom forms
- Ribbon tabs
- Task panes
When the Goal Seek command is selected from the Command Library as the shortcut target, it displays as command://GoalSeek or command://GoalSeekCommandAdapter (legacy syntax).
Shortcut parameters
This command uses the following shortcut parameters:
| Item | Description |
|---|---|
|
Set cell |
The cell that contains the formula that you want to resolve. For example: |
| To value | The formula result that you want. You can enter a numeric value or you can look up a value from a specified cell reference. The cell reference can be entered as either Sheet1!B5 or [Sheet1!B5]. (The bracket option is for consistency with other form-related settings that read a cell value.) |
| Changing cell |
The cell that contains the input value that you want to adjust. For example: This cell must be referenced by the formula in the cell that you specified as the Set cell. |
| Starting point |
A valid starting point for the changing cell. This setting is intended to avoid errors resulting from invalid formulas (such as dividing by zero). Enter a numeric value. |
|
Show Error |
Specifies whether an error message is shown to the user if the specified goal cannot be achieved. This option is enabled by default. If disabled, then no error message is displayed to the user. It is assumed that you have set up your own error handling within the file in this case. |
|
Processing step |
Specifies when the command will be executed during the form update process. This option only applies when using the command in an Axiom form. By default, this is set to Active Client Spreadsheet - After Processing, which means that the command will be performed on the active client spreadsheet, after the full form update process is complete. The default processing step assumes the Axiom form is intended to be used as a dialog in the Excel Client or Windows Client, and the goal seek calculations should be performed on the active client spreadsheet. If instead you want goal seek calculations to be performed on the Axiom form itself (as a standard, self-contained form), then you should change the processing step to occur within the form context (most likely to Form - After AQ Refresh). For more information, see Timing of command execution and Axiom form update process. |
NOTE: The cell references used for Set cell, To value, and Changing cell must all be located on the same sheet.
Visibility
In ribbon tabs and task panes, items using this command are visible if the active file is a spreadsheet. You can use the Show restricted item option in the task pane or the ribbon tab to force items that use this command to be visible at all times (but grayed out if unavailable for use).
In Axiom forms, the command used does not impact whether the button is visible or enabled.
