Document Solutions for Excel, .NET Edition | Document Solutions
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

    Reference

    IRange Interface
    IRange Members