GoalSeek
TryCalculate Method (CellRange, Double, CellRange, Double)
|
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,
double guess
)
Public Function TryCalculate (
targetCell As CellRange,
targetValue As Double,
variableCell As CellRange,
guess As Double
) As GoalSeekResult
public:
GoalSeekResult^ TryCalculate(
CellRange^ targetCell,
double targetValue,
CellRange^ variableCell,
double guess
)
member TryCalculate :
targetCell : CellRange *
targetValue : float *
variableCell : CellRange *
guess : float -> GoalSeekResult
Parameters
-
targetCell
-
Type:
Spire.Xls
CellRange
-
targetValue
-
Type:
System
Double
-
variableCell
-
Type:
Spire.Xls
CellRange
-
guess
-
Type:
System
Double
Return Value
Type:
GoalSeekResult
See Also