GoalSeek
TryCalculate Method (CellRange, Double, CellRange)
|
Try goal seek calculate.
Namespace:
Spire.Xls
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public GoalSeekResult TryCalculate(
CellRange targetCell,
double targetValue,
CellRange variableCell
)
Public Function TryCalculate (
targetCell As CellRange,
targetValue As Double,
variableCell As CellRange
) As GoalSeekResult
public:
GoalSeekResult^ TryCalculate(
CellRange^ targetCell,
double targetValue,
CellRange^ variableCell
)
member TryCalculate :
targetCell : CellRange *
targetValue : float *
variableCell : CellRange -> GoalSeekResult
Parameters
-
targetCell
-
Type:
Spire.Xls
CellRange
-
targetValue
-
Type:
System
Double
-
variableCell
-
Type:
Spire.Xls
CellRange
Return Value
Type:
GoalSeekResult
See Also