Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / 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
    boolean goalSeek( 
       double goal,
       IRange changingCell
    )

    Parameters

    goal
    Specifies the desired goal value.
    changingCell
    Specifies the cell to change.

    Return Value

    True if the specified goal value is successfully found, otherwise False.
    See Also