GrapeCity.Documents.Excel Namespace / IRange Interface / GoalSeek Method
Specifies the desired goal value.
Specifies the cell to change.
In This Topic
GoalSeek Method
In This Topic
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.
Syntax
System.bool GoalSeek( 
   System.double goal,
   IRange changingCell
)

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.
See Also