FarPoint.Win.Spread.FpSpread.GoalSeek

GoalSeek Method

GoalSeek(int, int, int, int, int, int, double)

Attempts to find the value for one cell that produces the desired formula result in another cell.

Declaration

public bool GoalSeek(int variableSheet, int variableRow, int variableColumn, int formulaSheet, int formulaRow, int formulaColumn, double desiredResult)

Public Function GoalSeek(variableSheet As Integer, variableRow As Integer, variableColumn As Integer, formulaSheet As Integer, formulaRow As Integer, formulaColumn As Integer, desiredResult As Double) As Boolean

Parameters

Type	Name	Description
int	variableSheet	Sheet index of cell that contains value to adjust
int	variableRow	Row index of cell that contains value to adjust
int	variableColumn	Column index of cell that contains value to adjust
int	formulaSheet	Sheet index of cell that contains the formula
int	formulaRow	Row index of cell that contains the formula
int	formulaColumn	Column index of cell that contains the formula
double	desiredResult	Formula result you wish to achieve

Returns

Type	Description
bool	true if value is found, false otherwise

GoalSeek Method