Attempts to achieve the specified goal, from the calculated result of the formula in the cell represented by this IRange, by modifying the specified changingCell.
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature.
System.bool GoalSeek(
System.double ,
IRange
)
Parameters
- goal
- Specifies the desired goal value.
- changingCell
- Specifies the cell to change.
Return Value
True if the desired result value is successfully found, otherwise False.